Jump to content
Main menu
Main menu
move to sidebar
hide
Navigation
Main page
Recent changes
Random page
freem
Search
Search
Appearance
Create account
Log in
Personal tools
Create account
Log in
Pages for logged out editors
learn more
Contributions
Talk
Editing
How to Add in Excel
Add languages
Page
Discussion
English
Read
Edit
Edit source
View history
Tools
Tools
move to sidebar
hide
Actions
Read
Edit
Edit source
View history
General
What links here
Related changes
Special pages
Page information
Appearance
move to sidebar
hide
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
Adding in Excel is a basic mathematical operation that can be performed on numerical data. Here are the steps to add in Excel: 1. Open a new or existing Excel file. 2. Enter the numbers you want to add in a column or row. For example, you could enter the numbers in cells A1 through A5. 3. Click on an empty cell where you want the sum to appear. For example, you could click on cell A6. 4. Type in the formula "=SUM(A1:A5)" (without the quotation marks) in the empty cell. This tells Excel to add up the numbers in cells A1 through A5. 5. Press Enter on your keyboard. The sum of the numbers should appear in the cell you selected. Alternatively, you can use the AutoSum feature in Excel to quickly add up a column or row of numbers. Here are the steps to use AutoSum: 1. Open a new or existing Excel file. 2. Enter the numbers you want to add in a column or row. 3. Click on an empty cell below or to the right of the numbers you want to add. For example, if you want to add up the numbers in column A, you could click on an empty cell in column B. 4. Click on the "AutoSum" button in the "Editing" group on the "Home" tab of the ribbon. The button looks like the Greek letter sigma (Ξ£) and is usually located near the top-left corner of the screen. 5. Excel will automatically select the cells it thinks you want to add. If Excel selected the correct cells, press Enter on your keyboard to see the sum. If Excel didn't select the correct cells, you can manually adjust the selection by dragging your mouse over the cells you want to add before pressing Enter. That's it! You should now be able to add numbers in Excel using either the SUM function or the AutoSum feature.
Summary:
Please note that all contributions to freem are considered to be released under the Creative Commons Attribution-ShareAlike 4.0 (see
Freem:Copyrights
for details). If you do not want your writing to be edited mercilessly and redistributed at will, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource.
Do not submit copyrighted work without permission!
Cancel
Editing help
(opens in new window)