Pulling names from a list

  • Thread starter Thread starter links_now
  • Start date Start date
L

links_now

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
 
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)
 
=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)
 
Back
Top