Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
GENERAL QUESTION - FORMULAS
I am setting up a budget and tracking income and expenses on an excel
spreadsheet. I have numerous headings - one for each account. What I am trying to accomplish is once I enter the account number and the amount, I want the amount to show up automatically under the heading of the same account number. Any help would be appreciated. THANKS! -- TP |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
GENERAL QUESTION - FORMULAS
Have a look at the Sumif function, the range is the account number column,
the criteria is the account number for totaling and the sum range is your amounts. "Tonya" wrote: I am setting up a budget and tracking income and expenses on an excel spreadsheet. I have numerous headings - one for each account. What I am trying to accomplish is once I enter the account number and the amount, I want the amount to show up automatically under the heading of the same account number. Any help would be appreciated. THANKS! -- TP |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
GENERAL QUESTION - FORMULAS
It is basically a "general ledger" that I am setting up. Where do I find the
Sumif Function? I am not sure I understand. -- Thanks, Tonya "Brian" wrote: Have a look at the Sumif function, the range is the account number column, the criteria is the account number for totaling and the sum range is your amounts. "Tonya" wrote: I am setting up a budget and tracking income and expenses on an excel spreadsheet. I have numerous headings - one for each account. What I am trying to accomplish is once I enter the account number and the amount, I want the amount to show up automatically under the heading of the same account number. Any help would be appreciated. THANKS! -- TP |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
GENERAL QUESTION - FORMULAS
To answer your question, use HelpSumif.
To give you more direction, general ledger applications are difficult to set up in Excel. If you are not a knowledgeable user, be prepared for a lot of frustration. Much better applications for your purpose are Quicken, Quickbooks or Money. -- Regards, Fred "Tonya" wrote in message ... It is basically a "general ledger" that I am setting up. Where do I find the Sumif Function? I am not sure I understand. -- Thanks, Tonya "Brian" wrote: Have a look at the Sumif function, the range is the account number column, the criteria is the account number for totaling and the sum range is your amounts. "Tonya" wrote: I am setting up a budget and tracking income and expenses on an excel spreadsheet. I have numerous headings - one for each account. What I am trying to accomplish is once I enter the account number and the amount, I want the amount to show up automatically under the heading of the same account number. Any help would be appreciated. THANKS! -- TP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas not recognizing new data | Excel Discussion (Misc queries) | |||
Pivot / general chart formatting question | Charts and Charting in Excel | |||
Printing formulas | Excel Discussion (Misc queries) | |||
Question On Excel Formulas | Excel Worksheet Functions | |||
General chart set up question | Charts and Charting in Excel |