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
|