Hi all,
I am trying to count a number of items where certain conditions apply. The first 4 conditions are single columns looking for a specific value. The last condition is searching 12 columns to find values less than a certain amount.
Individually, these 2 formulas work:
=COUNTIFS(WaterNoDup!$D$5:$D$15000,$AC$7,WaterNoDup!$E$5:$E$15000,$AC$8,WaterNoDup!$F$5:$F$15000,$AC$9,WaterNoDup!$K$5:$K$15000,$AC$10)
and
=COUNTIFS(WaterNoDup!$R$5:$AC$15000,C9)
Together like below, they return a #VALUE answer.
=COUNTIFS(WaterNoDup!$D$5:$D$15000,$AC$7,WaterNoDup!$E$5:$E$15000,$AC$8,WaterNoDup!$F$5:$F$15000,$AC$9,WaterNoDup!$K$5:$K$15000,$AC$10,WaterNoDup!$R$5:$AC$15000,C9)
What am I doing wrong?
Thanks!
Bookmarks