Variation of SumIf formula

  • Thread starter Thread starter cmharri123
  • Start date Start date
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...??
 
Hi

I would suggest using SUMPRODUCT()

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

Andy.
 
Back
Top