how to count entries in one column based on critieria in another c

J

jw

The data looks like:
State Hours
------ --------
Closed 0.00
Resolved 0.1
cancelled 0.00
Resolved 0.00
etc etc

I want to count the number of entries where state = resolved and hours >
0.00.
 
J

Jarek Kujawa

=SUMPRODUCT((A1:A10="Resolved")*(B1:B10>0))

or

=SUM(IF(A1:A10="Resolved")*(B1:B10>0),1)
(CTRL+SHIFT+ENTER this formula as it is an array-formula)

adjust ranges to suit

pls click YES if this helped
 
Top