count matched rows

[cape]

I need to count all rows that have "15-1" in one column(G:G) and
then 4.01 in column O:O.


So if 4 is in g and o is > then 4.01. dont want that counted.

Thanks in advanc

 

[Peo Sjoblom]

One way

=SUMPRODUCT(--(G2:G100="15-1"),--(O2:O100>4.01))

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(G1:G1000="15-1"),--(O1:O1000>4.01))

Note: SUMPRODUCT does not accept ranges like O:O

Frank