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

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.

xenou

MrExcel MVP
Joined
Mar 2, 2007
Messages
16,836
Office Version
  1. 2019
Platform
  1. Windows
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)
 

Forum statistics

Threads
1,181,055
Messages
5,927,863
Members
436,573
Latest member
CMR237

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
Top