| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sorting and matching rows of names with Socials with master list and eliminating the extra names | Excel Worksheet Functions | |||
| create a random list of names from a list of names in EXCEL | Excel Worksheet Functions | |||
| Pulling a Summary List from a Larger List | Excel Discussion (Misc queries) | |||
| filter 400 names from list 1 from list 2 with 4000 names | Excel Worksheet Functions | |||
| find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Hybrid Mode
