COUNTIF and OR
 

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.

COUNTIF and OR
 

=SUMIF(A:A,"Toyota *",B:B)

HTH
--
AP

"Annika" a écrit dans le message de news:
...
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.

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.

COUNTIF and OR
 

=SUMPRODUCT(SUMIF(A:A,{"Toyota Yaris","Toyota Corolla"},B:B))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Annika" wrote in message
...
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.

COUNTIF and OR
 

Thanks all of you, it's working.

regards Annika

COUNTIF and OR
 

Try something like this:

With your data list in A1:E5

F2: =INDEX($A$1:$E$1,1,MATCH(MAX(B2:E2),A2:E2,0))

Is that something you can work with?
***********
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.

COUNTIF and OR
 

Obviously, this post has nothing to do with THIS topic :/

I've got to get my computer fixed...
There's a loose nut in front of my keyboard!

***********
Regards,
Ron

XL2002, WinXP


"Ron Coderre" wrote:

Try something like this:

With your data list in A1:E5

F2: =INDEX($A$1:$E$1,1,MATCH(MAX(B2:E2),A2:E2,0))

Is that something you can work with?
***********
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.