Counting based on a formula result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting based on a formula's result 6
Please help with countif formula 4
Formula to assist with counting dates 2
Pivot tables calculated fields 2
counting dates using SUMPRODUCT 4
Excel Countifs/Sumproduct with mutil Or statement 3
counting formula 8
count even-numbered values in a range 5

Back
Top