running total of specific data

  • Thread starter Thread starter ameegrl
  • Start date Start date
A

ameegrl

I have a spread sheet with multiple catagories. I want a running total of
just specific catagories. Example; each time a "towels" is entered I want it
to total with the last "towels" entry. Help?
 
Assume 'towels' and the like are in column A, with count in column B, then
in any column EXCEPT a or b you could use this formula:
=SUMIF(A:A,"towels",B:B)
Change "towels" to any other item for different results, or separate running
totals elsewhere on the sheet.
 
Thank you!! Worked beautifully, just had to adjust slightly to apply a
running total.
Have a great day.......
 
Back
Top