View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JLatham JLatham is offline
external usenet poster
 
Posts: 2,203
Default 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?