distillerjunkie
New member
- Joined
- Mar 16, 2016
- Messages
- 33
- Reaction score
- 0
- Points
- 0
=SUM(COUNTIFS('Jan 22-26'!A:A,"Andy Ryan",'Jan 22-26'!D,"Y",'Jan 22-26'!E:E,1,'Jan 22-26'!E:E,2))
I need this to read 1 OR 2 not 1 AND 2. There might be no 1's, there might be no 2's. I need it to count them if they're available.
Essentially, If column A is "Andy Ryan", Column D is "Y", and Column E has a 1 and/or a 2, then SUM.
I need this to read 1 OR 2 not 1 AND 2. There might be no 1's, there might be no 2's. I need it to count them if they're available.
Essentially, If column A is "Andy Ryan", Column D is "Y", and Column E has a 1 and/or a 2, then SUM.
Last edited by a moderator: