running total of specific data

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?
 
J

JLatham

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.
 
A

ameegrl

Thank you!! Worked beautifully, just had to adjust slightly to apply a
running total.
Have a great day.......
 

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

Top