=SUMIF($D$4:$E$8,"Buick",$E$4:$E$8)

Where d4:e8 is the entire selection and e4:e8 is the #. "Buick" is the car
that will be totaled. :) Hope they had insurance.

Anyhow, the absolutes are so that you can create the formula once and then
fill it to however many different car types you have and just modify the
criteria to the other car.

An even better way:

Buick 6.00

Buick 4.00
Ford 3.00
Buick 2.00
Ford 6.00
Chevy 9.00

The formula in the cell with 6.0 (or D2) is =SUMIF($D$4:$E$8,C2,$E$4:$E$8)

" wrote:

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