Counting type of incidents

M

Mike G

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
 
P

PCLIVE

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
 
B

bj

try
=sumproduct(--(A1:100="A"),--(B1:B100<>""))
countif is faster for just the number of As

the "--( " changes the logical true false to numeric 1 0
the arrays must be the same size and cannot refer to a full column.
 
M

Mike G

Great....was able to "monkey" with the formula somewhat and got it to work.
Was wondering what was the significance of the "<>" portion in the formula
(B1:B100<>""))
 
P

PCLIVE

That looks at the cells that are not blank in B1 to B100.
B1:B100 is <> (anything other than, or greater than or less than) nothing.

I didn't think that's what you wanted, but glad it's working for you.
 
Top