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