How to Add in Excel (Excel Sum) with Examples

-

|

Introduction

There are different ways to add numbers in Excel. You could simply select the cells containing the data. Use AutoSum or Excel SUM function directly. You could also add in Excel using Excel SUMIF function. This will add cells that meet a specified criteria.

In this guide you will learn different ways you can add in Excel.

How to Add Columns in Excel (AutoSum and SUM)

One easy way to add in Excel is to select all the values you want to add. Excel will automatically sum the values. Use this method if you want to simply view the total of the numbers in a column or row.

Advertisement

If you look beneath Excel you will see the total of the selected values (highlighted in red below). Excel will also display the COUNT and AVERAGE of the selected numbers.

Another method is to use AutoSum. Here are the steps to use AutoSum:

  • Click on the cell below the cells you wish to add. In the image below this will be cell B8.
How to add in Excel with AutoSum
  • Next, click the Formulas tab. Then click AutoSum.
 How to Add Columns in Excel with AutoSum
  • When you click AutoSum, Excel will automatically add all the numbers in the column. Click Enter on your keyboard. All the numbers will be added. See the second image below.
How to Add Columns in Excel with AutoSum
How to Add Columns in Excel with AutoSum
You could also access AutoSum from Home => AutoSUM

Finally, for this section you can add in Excel by directly entering the SUM formula.

Here is how:

  • Double-click the cell you want to have the total value. Then enter equal sign (=), followed by the word SUM. When you enter SUM, Excel will automatically enter the opening bracket, “(“. Next, select the cells you wish to add and press Enter.

How to Add in Excel with Criteria (SUMIF)

To add in Excel using a criteria (condition) use the SUMIF function.

Below is the syntax of the SUMIF function:

SUMIF(range, criteria, [sum_range])

range – the range of cells you are adding
criteria – the condition the cell specified in range must meet before it is included
sum_range – this is an optional value. use this to specify the range to add if different from range.

In the following examples, I will add values in cells B3 to B7 if the value is greater than 30. Here is the formula.

=SUMIF(B3:B7,">30")

And the result:

How to Add in Excel with Criteria (SUMIF example)

Only cells B5 to B7 are included in the addition. They are the only cells with values greater than 30.

Advertisement

How to Use Excel Table to Add Only Filtered Values

Before you can use this method, you need to first convert your data into a table.

To use this method, follow the steps below:

  • Select the all the column containing your data, including the column headers.
Use Excel Table to Add Only Filtered Values
  • Then press Ctrl + T. The Create Table option will load. To create a table with the selected cells, click Ok.
  • To include a total row, with the table selected, click Table Design. Then check the box beside Table Row. This will add a Total row at the end of the table.

By default all values are included in the total. To remove a row from the sum, follow the steps below:

  • Click on the arrow point downwards on one of the headers.
  • To remove an item from the total value, uncheck the item. Then click Ok. The item will be removed from the list. Excel will then only have a total of the items in the list. See the second table below.

Conclusion

In this guide I demonstrated different ways you can add numbers in Excel: By selecting cells, using AutoSum or using the SUM or SUMIF formula. The guide also demonstrated how to add with a table. I hope this was helpful.

If you have a comment or a question use the “Leave a Reply” form at the end of the page. Alternatively, you could share your experience for other readers to benefit from.

Other Helpful Guides

Additional Resources and References

LEAVE A REPLY

Please enter your comment!
Please enter your name here

FEATURED POSTS

network discovery keeps turning off server 2016

How to Fix Network Discovery If it Keeps Turning Off in Server 2016

Does network discovery keep turning off in your Windows server 2016? It is likely that one of its dependent services is not...
how to install windows 10 1903 update manually

How to Install Windows 10 1903 Update Manually

Windows 10 1903 Update was released in May, 2019. But some users are not yet offered the update via automatic update. The...
spotify web player not working

Spotify Web Player Not Working [Fixed]

Introduction Spotify Web Player may stop working for you with the following error messages: "Spotify Web Player an Error...
DISM.exe /Online /Cleanup-Image /Restorehealth

DISM.exe /Online /Cleanup-Image /Restorehealth Explained

What is DISM.EXE /Online /Cleanup-image /RestoreHealth? "DISM.exe /Online /Cleanup-Image /Restorehealth" is a DISM command that repairs issue with the...
DHCP Relay agent

DHCP Relay Agent: Configuration in Windows Server 2016

What is a DHCP Relay Agent? A DHCP Relay Agent allows DHCP clients in a different network subnet to...

TRENDING POSTS

Remote Desktop Connection

Remote Desktop Connection an Internal Error Has Occurred [Fixed]

Introduction I recently received the error message "Remote Desktop Connection an Internal Error Has Occurred". It was strange because...

Find My Samsung: Register and Use Samsung Find my Mobile

Introduction Ever wondered how you could find your Samsung phone if you lost it? Find my Samsung or Samsung...
What is the Difference Between PowerShell and CMD?

Windows Powershell vs CMD: Differences and Similarities

Introduction This short guide compares Windows PowerShell vs CMD (Windows command prompt). I will cover the history and nature...
Spotify No Longer Supports this Version of Microsoft Edge

Spotify No Longer Supports this Version of Microsoft Edge [Fixed]

Introduction When you open Spotify web player on Microsoft Edge, you may receive the error message "Spotify No Longer...
Windows 10 Won't Boot

Windows 10 Won’t Boot With Black Screen? 3 Ways to Fix It

Why Won't Windows 10 Boot Up? If your Windows 10 stops with a black screen, the first question in...

BEST OF ITECHGUIDES

Excel Not Equal

Excel “Not Equal” Comparison Operator: Syntax, Examples

Introduction Excel "Not Equal" is a Comparison operator that compares two values. "Not Equal" will return TRUE if the...
RAID 5 vs RAID 6

RAID 5 vs RAID 6: Differences, Benefits and Disadvantages

What is RAID 5 vs RAID 6? RAID 5 and RAID 6 uses striping with distributed parity technique. However,...

Change User Name and Rename User Folder in Windows 10

Introduction There are so many reasons why you may want to change user name in Windows 10 or rename...
how to move columns in excel

How to Move Columns to Rows and Rows to Columns in Excel

Introduction If you receive some Excel data in columns, you can easily move the columns to rows in Excel...
system restore windows 10

How to Enable and Use System Restore in Windows 10

Introduction System restore in windows 10 is a very important tool that is probably ignored by most users. But...

RECENT POSTS

disable cortana windows 10 featured

How to Disable Cortana in Windows 10 (2 Methods)

Introduction Some Windows 10 users may not like Cortana. Solution? Disable Cortana. You are probably reading this because you...
bootrec /fixboot access is denied

How to Fix BootRec /FixBoot Access is Denied Error in Windows 10

Introduction BootRec /FixBoot Access is Denied Error in Windows 10? This error is likely caused by corrupt EFI directory.
Reset Windows 10

How to Reset Windows 10 (2 Methods)

Introduction If your Windows 10 is broken, one available way to fix it is to use Windows 10 reset....
system restore windows 10

How to Enable and Use System Restore in Windows 10

Introduction System restore in windows 10 is a very important tool that is probably ignored by most users. But...
windows has stopped this device code 43

How to Fix Windows Has Stopped this Device Code 43 Error

Introduction Sometimes you may receive "Windows has stopped this device code 43" error. This error is likely to come...
Windows could not automatically detect this network's proxy settings

How to Fix “Windows Could not Automatically Detect this Network’s Proxy Settings”

Introduction You suddenly lose the ability to connect to the internet. Then you run network troubleshooter and it returns...
printer offline

5 Ways to Restore Your Printer Online If Status is Offline

Introduction Is your printer offline? Setting it online is very simple but sometimes it is more than just setting...

How to Fix “BootMgr is Missing” Error in Windows 10

Introduction If you receive Fix "BootMgr is missing" Error in Windows 10, the default response is panic! But you...
windows 10 search featured

How to Fix Windows 10 Search If it Stops Working

Introduction Are you having troubles with Windows 10 search? Apparently, it is a fairly common problem with a number...
oooops, something went wrong. reload

How to Fix “Oooops something went wrong. reload” Spotify Error

Introduction If you receive "Oooops something went wrong. reload" Spotify error, do not panic. The fix is simpler than...

MUST READ

Spotify No Longer Supports this Version of Microsoft Edge

Spotify No Longer Supports this Version of Microsoft Edge [Fixed]

Introduction When you open Spotify web player on Microsoft Edge, you may receive the error message "Spotify No Longer...
Dynamic disks bs basic disks

Dynamic Disk vs Basic Disk: How to Convert to Dynamic Disk

Introduction Dynamic disk type was introduced by Microsoft with Windows 2000. Earlier versions of Windows Operating Systems used Basic...
How to Calculate Variance in Excel

How to Calculate Variance in Excel

Introduction Variance measures the spread between numbers in a data set. You can calculate variance in Excel using the...

How to Alphabetize (Sort Lists or Tables) in Microsoft Word

Introduction You can alphabetize (sort) a list or table in Microsoft word by number, date or text. You can...
windows 10 start menu not working featured

How to Restore Windows 10 Start Menu if it Stops Working

Introduction Windows 10 start menu not working? You are not alone! A number of Windows 10 users report that...

By using this website you agree to accept our Privacy Policy and Terms & Conditions