Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
adding totals on item number match
Hello,
I'm sure this is simple for someone: I have a list of items with counts. On the last row for a particular item, I want to add up the counts for each previous matching line and create a new 'total'. Some items have only one row, others have upto 4 with counts in each. I want one row per item with a total count in a new column, added at the end. I've searched help and I'm a little confused about the best way to approah this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
match item in 2 excel files | Excel Discussion (Misc queries) | |||
Calculate PivotTable Item Totals Based On Cell Contents? | Excel Worksheet Functions | |||
PivotTable Grand Totals By Item | Excel Discussion (Misc queries) | |||
does item match any in column B | Excel Discussion (Misc queries) | |||
How do I use a" item description" in excel to consolidate totals? | Excel Discussion (Misc queries) |