Hi there,

I'm trying to use the COUNTIFS function.

The following example works fine (it provides a value of 1):

whyworks.png

Formula: copy to clipboard 
=COUNTIFS(G21:J21,"A>B",K21:N21,"B>C",O21:R21,"A>C")


However this example does not (it provides a value of 0):

why.png

Formula: copy to clipboard 
=COUNTIFS(G51:J51,"A>B",K51:N51,"C>B",O51:R51,"A>C")


The cells that this formula is counting from (columns G to R) are all based on IF functions where na is the false value, but seeing as the first COUNTIFS formula worked I don't see why this should make a difference?

Any thoughts on what might be happening here?

Thanks very much.