COUNTIFS with only 2 cells

[Kmanbozzy]

I must not understand the countifs function like i thought i did... I just want to check 2 cells if they = 0. here is my formula =COUNTIFS(E6,0,E9,0) i've tried "=0" and i still get the same results. both cells are numbers and = 0 but the result is 1. it should be 2. E7 and E8 equal 0 as well, but i dont want to count those in my formula so that's why i'm not using just countif.

What am i doing wrong?

 

[gaz_chops]

Countifs is counting it as 1 if both cells = 0, which is correct, try it as

=COUNTIFS(E6,0)+COUNTIFS(E9,0)

 

[mainfolder]

Countifs function is for multiple criteria. You have only one criteria. So you should use =countif(A6:A9,0)
This will scan the range A6:A9 and return number of zeros in the range.

 

[Kmanbozzy]

ohhhh wow i feel silly, thanks!!

 

[jasonb75]

Multiple ranges in countifs are tested parallel, if both = 0 then it counts as 1, if neither = 0 then it counts as 0.

You don't need countifs to test individual cells anyway, simple logical tests work fine for that. =(E6=0)+(E9=0)

@mainfolder I think that you missed this part of the post,

E7 and E8 equal 0 as well, but i dont want to count those in my formula so that's why i'm not using just countif.