I need some help entering formulas.

Ryant34231

New Member
Joined
Aug 2, 2007
Messages
7
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
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
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)
 
Upvote 0

Forum statistics

Threads
1,218,695
Messages
6,143,953
Members
450,518
Latest member
ShAzeem

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top