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

[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.

 

[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

 

[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

 

[Max]

=SUMPRODUCT((A3:A6="Resolved")*(B3:B6>0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik

 

[Max]

=SUMPRODUCT((A3:A6="Resolved")*(B3:B6>0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik