Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Basic formula
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Basic formula
On Aug 18, 3:35 pm, Mana wrote:
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? =SUMIF(Sheet1!C:C,A1,Sheet1!I:I) You'll have to adjust the ranges. And make sure your account numbers have no typos. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
basic formula | Excel Worksheet Functions | |||
Basic Future Value Formula & Interest Rate Formula | Excel Discussion (Misc queries) | |||
Another Basic formula I should know (but Don't) | Excel Worksheet Functions | |||
Basic if formula | Excel Discussion (Misc queries) | |||
Basic if formula | Excel Discussion (Misc queries) |