Summarize Values by Change in Value of 2nd Digit

[Smokeyham]

I have a list of account numbers, and associated budget amounts:

Account # Budget
6801 5,671
6802 20,981
6803 55,678
6804 5,992
6901 1,839
6902 89,271
6903 66,532


I would like Excel to summarize the total of the amounts in the list of accounts based on when the 2nd digit in the account number changes, (i.e. when 6800-series changes to 6900-series). Here is what the ideal output would look like:

Account # Budget
6801 5,671
6802 20,981
6803 55,678
6804 5,992
68XX 88,322

6901 1,839
6902 89,271
6903 66,532
69XX 157,642

Any suggestions on a way to do this?

Thanks for any help.