I need some help entering formulas.

[Ryant34231]

I am currently in the process of taking all my business recipts and logging the information on my computer. The idea I have is a way to set up excel to do all the math itself. I would like to enter my numbers in a roq and in each column it automaticly adds or subtracts for the grand total. If anyone can help please contact me. Thank you.

Ryan Turner
Sarasota,Fl

 

[PaddyD]

hi - welcome to the board.

someone has almost certainly built something like that already - have a browse of MS templates:

http://office.microsoft.com/en-us/templates/default.aspx

 

[xenou]

Check out the help files (click F1) on SUM. Generally you input all your numbers in a column, and have a total above or below, using the SUM function. You can also use rows in the same way, although rows going across is visually harder to work with when there are many numbers. For instance, if you have numbers in A1 through A10 (down), then in A11 you would enter =SUM(A1:A10). If you have numbers in A1 through J1 (across), then in K11 you would enter =SUM(A1:J1).

Note that you can change the default direction of the cursor movement on the Edit tab under:
Tools | Options
Just select a value for "Move Selection after Enter" (DOWN/RIGHT/LEFT/UP)