Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Subtotal function
I have a spreadsheet that I need a total for one column at each change in
another column. Example: abc 0 abc 15 abc 22 abc 0 def 5 def 9 def 17 Would produce the following: abc 37 def 31 Thanks in advance for helping! : ) |
#2
|
|||
|
|||
That is exactly what datasubtotals will do and if you want it to return just
the same as in your post just click on the 2 in the subtotal pane to the left Regards, Peo Sjoblom "Kyli" wrote: I have a spreadsheet that I need a total for one column at each change in another column. Example: abc 0 abc 15 abc 22 abc 0 def 5 def 9 def 17 Would produce the following: abc 37 def 31 Thanks in advance for helping! : ) |
#3
|
|||
|
|||
Hi
use a pivot table for this or use 'Data - subtotals' -- Regards Frank Kabel Frankfurt, Germany "Kyli" schrieb im Newsbeitrag ... I have a spreadsheet that I need a total for one column at each change in another column. Example: abc 0 abc 15 abc 22 abc 0 def 5 def 9 def 17 Would produce the following: abc 37 def 31 Thanks in advance for helping! : ) |
#4
|
|||
|
|||
Hi Frank
When I pull up data - subtotal, I get "At each change in", "Use Function", and "Add subtotal to". I used At each change in: Col A, Use Function: Sum, and Add Subtotal to: Col B. For some reason, all I get are zeros. Any thoughts? Thanks, Kyli "Frank Kabel" wrote: Hi use a pivot table for this or use 'Data - subtotals' -- Regards Frank Kabel Frankfurt, Germany "Kyli" schrieb im Newsbeitrag ... I have a spreadsheet that I need a total for one column at each change in another column. Example: abc 0 abc 15 abc 22 abc 0 def 5 def 9 def 17 Would produce the following: abc 37 def 31 Thanks in advance for helping! : ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal function | New Users to Excel | |||
Formula to list unique values | Excel Worksheet Functions | |||
Subtotal And Countif | Excel Discussion (Misc queries) | |||
Excel's Pivot Table & Subtotal function should have a median fie. | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions |