| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplicate Running Total Grand Total In Pivot Table | Excel Discussion (Misc queries) | |||
| running total where old data is replaced by new data | Excel Discussion (Misc queries) | |||
| running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
| running total and average of that total after 3 events | Excel Discussion (Misc queries) | |||
| Can you use two running total data items to calc a third data item | Excel Discussion (Misc queries) | |||
Linear Mode
