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! : )

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! : )

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! : )

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! : )