| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I use a" item description" in excel to consolidate totals?
I have a inventory spreadsheet in Excel and it as about 8 columns by 47 rows
of information. I am tracking items received by date, which causes multiple entries with the same "Item Descrption". How do I keep a running total of any given item that has more than one entry? |
|
#2
|
|||
|
|||
|
Hi
not completely sure about your data layout but maybe a pivot table is what you're looking for. Also have a look at the SUMIF function -- Regards Frank Kabel Frankfurt, Germany "D" schrieb im Newsbeitrag ... I have a inventory spreadsheet in Excel and it as about 8 columns by 47 rows of information. I am tracking items received by date, which causes multiple entries with the same "Item Descrption". How do I keep a running total of any given item that has more than one entry? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
| Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
| Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) | |||
| Description box in excel | Excel Discussion (Misc queries) | |||
| How to remove an Excel Main Menu item inserted by .xla file | Excel Discussion (Misc queries) | |||
Linear Mode
