I need to know how to auto sum column B based on the account number in column A for multiple accounts. I.E. if you enter the account number in to the A column and the dollar amount into the B column. Then have it auto sum based on account number onto sheet 2 under the corresponding account number. The purpose is to be able to enter all purchases for all account on sheet one and have it sort and total each account on sheet 2 so that i know the balances.