On one tab, I have in column C the account number, in column I, I have the
amount. There are are series of account numbers. On a separate tab (summary
sheet), I have the account number in column A and in column B I want every
amount from the first tab to sum in column B, next to the associated account
number. How do I do that so it is a constant formula that does not have to
be manipulated every month?