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)

--
Regards,
Dave


"expicitd" wrote:

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