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