Thread: how to count entries in one column based on critieria in another c
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JW JW is offline
external usenet poster
  
Posts: 22
Default 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
Reply With QuoteReply With Quote