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