View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PCLIVE PCLIVE is offline
external usenet poster
 
Posts: 1,311
Default Counting type of incidents

Try something like this:

=SUMPRODUCT(--($A$1:$A$100="A"),--($B$1:$B$100="Resolved"))

You can adjust the range ($A$1:$A$100 and $B$1:$B$100) as necessary.

HTH,
Paul

"Mike G" wrote in message
...
I have a continuing list of "incidents". They are classified as type A or
B or C or D. I can "countif" the type and get totals of each, but what I
am having trouble with is whether or not not they have been resolved or
still open. The next column will have a text type answer in it if resolved
and left blank if not. The result will be somthing like : Type A has 40
incidents and 25 have been resolved. TIA for any suggestions