How do I use a" item description" in excel to consolidate totals?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup across multiple columns within multiple sheets 2
Excel 2003 Pivot Table - Grand Total 4
Count if using multiple date criteria 4
Using Excel to capture Inventory 1
keeping subtotals accurate to reflect sorting... 1
Help: Using CONCATENATE (and a COUNT?) for a total result 3
How do I use the data consolidate function? 3
HELP!!! 1

Back
Top