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.
|