Thread: COUNTIF and OR
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default COUNTIF and OR

Apart from just matching cells starting with "Toyota", you could try this:

=SUMPRODUCT((A1:A5={"Toyota Corolla","Toyota Yaris"})*B1:B5)

or this
=SUMIF(A1:A5,"*Corolla",B1:B5)+SUMIF(A1:A5,"*Yaris ",B1:B5)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Annika" wrote:

I have this table and want to use COUNTIF to find out:
If column A is Either Toyota Corolla OR Toyota Yaris, then sum up column B

A B

Toyota Corolla 15 000
Toyota Yaris 5 000
Volvo 20 000
Saab 10 000
Toyota Yaris 10 000
So I want to get the sum of 30 000.