Variation of SumIf formula

C

cmharri123

I am trying to make my formula count up a 'Car Model' column dependin
on the text that is held in a previous column.

Obviously, I could normally use SumIf but the column that I want to b
counted up is Alpha and not numeric.

The above might not be the best description (!) but basically I want t
be able to count up how many Focus, Mondeo etc are in Column K (fo
example) if the contents of column A read 'Fleet Sale'... etc...

Can anyone help...??
 
A

Andy B

Hi

I would suggest using SUMPRODUCT()

=SUMPRODUCT((K2:K100="Focus")*(A2:A100="Fleet sale"))

Andy.
 

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

Top