Balance from multiple contractors

I have a construction project with over 100 different contractors and have amounts paid to each. This information was gathered from a check ledger. I have the information organized by check number. From this, I need to arrange a value column that will add the current payment to the previous payment total. For instance, the first payment is $100 - this balance is $100. The second payment to this contractor is $50 - the new balance is $150, etc.

Once these balances are created, I will be able to use a filter to sort by each contractor then by the check number they have received. Please let me know the formatting I should use to calculate the balances. Also, is there a way to tie this spreadsheet into Access so if the values are updated the Access database will also update?

hi,

not sure if this is what you want but

this will add the sum after it is filtered

put this is any cell

=subtotal(9,a1:a100)

hope this helps

steve