Pulling names from a list
 

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

Pulling names from a list
 

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

Pulling names from a list
 

=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

Pulling names from a list
 

Exactly what I was trying to say, just a little more concise.

"T. Valko" wrote:

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