Counting based on a formula result

J

Jeff

Hi,

I wanted to count cells based on the result of the formula, "Type(A1)"

I wanted to accomplish this in a single formula. I have used sumproduct to
count, for example to count the number of occurances of the word "Car" in a
given range:

=Sumproduct((A1:A100=Car)*1)

Is there anyway to do this for the "Type(A1:A100)", or is there an array
formula?


Thanks
 
Top