| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Vlookup sum total
Hello:
I have a list from From B2:F25 of items and amounts. B2 C2 D3 D4 E2 F2 Plastic 1 Metal 3 Stone 4 Wood 2 Plastic 1 Wood 1 Plastic 2 Metal 1 I would like to total in a cell the total amount of plastic in the whole chart. The total should be 4 not the amount of times the word plastic appears in the chart. I need the total amount of plastic ordered. Thanks for any help. Art. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup to total hours billed | Excel Worksheet Functions | |||
| Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
| Excel 2002 : Any single button to get sub total and grand total ? | Excel Discussion (Misc queries) | |||
| Using VLookup, Displacement, SumIF to total and average | Excel Discussion (Misc queries) | |||
| MY VLOOKUP IS RETURNING N/A AND THEREFORE MY TOTAL SUM AT THE BOT. | Excel Discussion (Misc queries) | |||
Threaded Mode
