Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF and OR
Thanks all of you, it's working.
regards Annika |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif Formula /Sort Bug??? | Excel Discussion (Misc queries) | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Combining IF and COUNTIF based on two columns | Excel Discussion (Misc queries) | |||
COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions |