How to Sum Selected Cells in Excel (4 Easy Methods)

If you are looking for some special tricks to sum selected cells in Excel, you’ve come to the right place. In Microsoft Excel, there are numerous ways to sum selected cells. In this article, we’ll discuss four methods to sum selected cells. Let’s follow the complete guide to learn all of this.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


4 Easy Methods to Sum Selected Cells in Excel

We will use four effective and tricky methods to sum selected cells in Excel in the following section. This section provides extensive details on four methods. You should learn and apply all of these, as they improve your thinking capability and Excel knowledge.


1. Using SUM Function to Sum Selected Cells

The following dataset shows sales for different months for a company, with the range of cells, C8: C12 selected to calculate total sales. Our main goal is to sum selected cells. Using the SUM function is the fastest way, to sum up, the selected cells. Let’s walk through the steps to find out how to sum selected cells in Excel.

Using SUM Function to Sum Selected Cells

📌 Steps:

  • Firstly, we will use the following formula in the cell C13:

=SUM(C8:C12)

Here, C8:C12 are the ranges of selected cells for different months, and the sum will be calculated based on these ranges.

  • Now, press Enter.

Using SUM Function to Sum Selected Cells

  • As a consequence, you will get the total sales for selected cells like the following.

Using SUM Function to Sum Selected Cells

Read More: How to Sum Range of Cells in Row Using Excel VBA (6 Easy Methods)


2. Sum Selected Cells Using AGGREGATE Function

Here, we use another method to sum selected cells by using the AGGREGATE function. Here, the AGGREGATE function returns an aggregate in a list or database. Let’s walk through the steps to find out how to sum selected cells in Excel.

Sum Selected Cells Using AGGREGATE Function

📌 Steps:

  • Firstly, we will use the following formula in the cell C13:

=AGGREGATE(9,,C8:C12)

Here, C8:C12 are the ranges of selected cells for different months, and the sum will be calculated based on these ranges.

Here, 9 is the function number, which means the SUM function.

  • Now, press Enter.

Sum Selected Cells Using AGGREGATE Function

  • As a consequence, you will get the total sales for selected cells like the following.

Sum Selected Cells Using AGGREGATE Function


Similar Readings


3. Utilizing SUBTOTAL Function in Excel

Here, we use another method to sum selected cells by using the SUBTOTAL function. Here, the SUBTOTAL function returns a subtotal in a list or database. Let’s walk through the steps to find out how to sum selected cells in Excel.

Utilizing SUBTOTAL Function in Excel

📌 Steps:

  • Fristly, we will use the following formula in the cell C13:

=SUBTOTAL(9,C8:C12)

Here, C8:C12 are the ranges of selected cells for different months, and the sum will be calculated based on these ranges.

Here, 9 is the function number, which means the SUM function.

  • Now, press Enter.

  • As a consequence, you will get the total sales for selected cells like the following.

Utilizing SUBTOTAL Function in Excel


4. Applying SUMIF Function in Excel

Here, we use another method to sum selected cells by using the SUMIF function. Here, the SUMIF function adds the cells specified by a given condition or criteria. Now, we are going to calculate the total sales for the months whose sales value was over $4500. Let’s walk through the steps to find out how to sum selected cells in Excel.

📌 Steps:

  • Fristly, we will use the following formula in the cell F5:

=SUMIF(C5:C12,F4)

Here, F4 is the criteria and C8:C12 are the ranges of selected cells for different months, and the sum will be calculated based on these ranges.

  • Now, press Enter.

Applying SUMIF Function in Excel

  • As a consequence, you will get the total sales for selected cells like the following.

Read More: Sum Cells in Excel: Continuous, Random, With Criteria, etc.


Conclusion

That’s the end of today’s session. I strongly believe that from now you may sum selected cells in Excel. If you have any queries or recommendations, please share them in the comments section below.

Don’t forget to check our website Exceldemy.com for various Excel-related problems and solutions. Keep learning new methods and keep growing!


Related Articles

Saquib Ahmad Shuvo

Saquib Ahmad Shuvo

Welcome to my Profile. I am working on and researching Microsoft Excel right now, and I will be posting articles about it here. I received a B.Sc. in Naval Architecture and Marine Engineering from the Bangladesh University of Engineering and Technology (BUET). Having studied naval architecture, I have a strong interest in research and development. Always try to learn from different sources and come up with creative solutions.

We will be happy to hear your thoughts

Leave a reply

5 Excel Hacks You Never Knew

Genius tips to help you unlock Excel's hidden features

FREE EMAIL BONUS

ExcelDemy
Logo