running total of specific data
 

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?

running total of specific data
 

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.


"ameegrl" wrote:

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?

running total of specific data
 

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

"JLatham" wrote:

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.


"ameegrl" wrote:

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?