Countif Function

**andrewc** · 06-21-2011, 04:44 AM

I am trying to count the number of times the values in A1:A1000 are greater than those in B1:B1000. Can someone please tell me how to achieve this using a COUNTIF function?

Thank You!

**Domski** · 06-21-2011, 04:48 AM

Try: =SUMPRODUCT(--(A1:A1000>B1:B1000))

Dom

**Colin Legg** · 06-21-2011, 04:48 AM

Hi,

Please Login or Register  to view this content.

**andrewc** · 06-21-2011, 05:00 AM

Excellent, thanks very much.

Is it possible to achieve the same result using COUNTIFS?

Thanks

**Colin Legg** · 06-21-2011, 05:09 AM

Hi Andrew,

In short, no.

You want a comparison like the comparison 1 picture attached, but you could can liken COUNTIF (or COUNTIFS) to the comparision 2 picture attached.