Counting type of incidents
 

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

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

Counting type of incidents
 

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.

"Mike G" wrote:

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

Counting type of incidents
 

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<""))



"bj" wrote in message
...
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.

"Mike G" wrote:

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

Counting type of incidents
 

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.

"Mike G" wrote in message
...
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<""))



"bj" wrote in message
...
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.

"Mike G" wrote:

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