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