If I understand...

=SUMIF(A1:A5,"Chevy",B1:B5)
=SUMIF(A1:A5,"Ford",B1:B5)
=SUMIF(A1:A5,"Buick",B1:B5)

Better to use cells to hold the criteria:

D1:D3 = Chevy, Ford, Buick

Then, in E1 and copied down to E3:

=SUMIF(A$1:A$5,D1,B$1:B$5)

--
Biff
Microsoft Excel MVP


" wrote
in message ...
If I have a list of products. The headings are as followed

Product #

Buick 4
Ford 3
Buick 2
Ford 6
Chevy 9

I need a formula and I can't change the order of the list to add up how
many
buicks ,fords, and chevys and put the sum in a particular cell. HELP