GENERAL QUESTION - FORMULAS

T

Tonya

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!
 
B

Brian

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.
 
T

Tonya

It is basically a "general ledger" that I am setting up. Where do I find the
Sumif Function? I am not sure I understand.
 
F

Fred Smith

To answer your question, use Help>Sumif.

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.
 
Top