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

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.

--
Thanks,
JW

how to count entries in one column based on critieria in anotherc
 

=SUMPRODUCT((A1:A10="Resolved")*(B1:B100))

or

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

adjust ranges to suit

pls click YES if this helped


On 27 Maj, 07:48, jw wrote:
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. *

--
Thanks,
JW

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

=SUMPRODUCT((A3:A6="Resolved")*(B3:B60))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"jw" wrote:
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.

--
Thanks,
JW