Sum by like data

E

expicitd

Question how can I use the SUM command to have it list the grand total for a
wtn everytime time it changes?
Example data

WTN BillAMt
1111111 1.00
1111111 4.26
1111111 5.32
1111111 8.62
2222222 9.36
2222222 83.20
2222222 15.20
2222222 8.20



End result

WTN BIllAmt
1111111 19.20
2222222 115.96
 
B

bpeltzer

If your data is sorted so that all like WTNs are continuous, use Data >
Subtotals. Select your data, then Data > Subtotals. Use the drop-downs to
apply Sum to BillAmt on changes of WTN. Note that this will use function 9
(sum) of the subtotal function.
(You could also create a pivot table, dropping WTN into the rows field and
BillAmt in the data field).
--Bruce
 
D

David Billigmeier

If WTN is in column A and BillAMt is in column B, use:

=SUMIF(A1:A100,"111111",B1:B100)
=SUMIF(A1:A100,"222222",B2:B100)
 
E

expicitd

The problem with Data > Subtotal is copying the end result to a txt file is
all the the data is copy over not just the subtotals (end result)
 
Top