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.

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.

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

  • Was this post Helpful?
  • YesNo

LEAVE A REPLY

Please enter your comment!
Please enter your name here

ADVERTISEMENTS

FEATURED POSTS

Best Christian Movies on Netflix

The 10 Best Christian Movies on Netflix

This Itechguide reviews the 10 best christian movies on Netflix. The movies are listed in reverse order – with the 10th movie...
How to Change Orientation in Google Docs

How to Change Orientation in Google Docs

This Itechguide teaches you how to change orientation in Google Docs. The guide covers steps to change orientation in Google Docs from...
How to Delete Google Photos

How to Delete Google Photos

This Itechguide teaches you how to delete Google Photos. The guide offers steps to delete Google Photos from the Google Photos App...
How to Install Windows 10 1909 Update Manually

How to Install Windows 10 1909 Update Manually

This Itechguide teaches you how to install Windows 10 1909 update manually. Windows 10 1909 (otherwise known as Windows 10 November update)...
How to Create a Poll on Facebook

How to Create a Poll on Facebook

This Itechguide teaches you how to create a poll on Facebook. You can create a poll on Facebook from a Facebook page...

AMAZON DEALS

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...

ADVERTISEMENTS

BEST OF ITECHGUIDES

vlookup google sheets

How to Use VLOOKUP in Google Sheets

Introduction VLOOKUP (Vertical lookup) in google sheets is used to search for a value in the first column of...
How to Move Images in Google Docs

How to Move Images in Google Docs

This Itechguide teaches you how to move images in Google Docs. The guide offers 3 high-level steps to move images in Google...
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...
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...

Get Help With File Explorer in Windows 10

Introduction Need to get help with the new file explorer in Windows 10? You are in the right place....

RECENT POSTS

How to Change Facebook Page Name

How to Change Facebook Page Name

This Itechguide teaches you how to change Facebook page name. The guide covers steps to change Facebook page name from a PC...
How to Change YouTube Channel Name

How to Change YouTube Channel Name

This Itechguide teaches you how to change YouTube channel name. The guide covers steps to change YouTube channel name from a PC.
How to Bold Text on Facebook Post

How to Bold Text on Facebook Post

This Itechguide teaches you how to bold text on Facebook post. The guide covers steps to bold text on Facebook post from...
Best Crime Documentaries on Netflix

The 10 Best Crime Documentaries on Netflix

This Itechguide reviews the 10 best crime documentaries on Netflix. The documentaries are listed in reverse order – with the 10th documentary...
Best Netflix Series

The 10 Best Netflix Series

This Itechguide reviews the 10 best Netflix series. The series are listed in reverse order – with the 10th series on top....

AMAZON DEALS

MUST READ

mobile hotspot greyed out windows 10

Mobile Hotspot Greyed Out on Windows 10, iPhone or Android [Fixed]

Introduction If mobile hotspot is greyed out on windows 10, iPhone or Android it is likely that you do...
windows cannot be installed on this disk

How to Fix “Windows Cannot be Installed on this Disk” Error

Introduction If you try to install Windows 10 on a non-Windows formatted hard driver you may receive "Windows cannot...
Best Family Movies on Netflix

The 10 Best Family Movies on Netflix

When you watch an awesome family movie on Netflix, it gives a lasting experience for the family. Most importantly, it creates beautiful...
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...
7 Ways to open Control Panel in Windows 10

7 Ways to open Control Panel in Windows 10

Introduction This guide demos 7 ways to open Control Panel in Windows 10. Options to...

AMAZON DEALS

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