=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