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.

** **

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

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

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

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

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

**Similar Readings**

**How to Sum Only Visible Cells in Excel (4 Quick Ways)****Sum Only Positive Numbers in Excel (4 Simple Ways)****Calculate Cumulative Sum in Excel (9 Methods)****How to Sum Multiple Rows in Excel (4 Quick Ways)**

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

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

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

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

What I want to be able to do is select a block of numbers, then right-click and get a few choices on what to show about these – sum, average, median, std deviation, for instance, without putting a formula in a cell. The answer should show up in a separate dialogue window when I select an operation.

Does Excel do this?

Thank you

Dave Gilblom, for your comment. Yes, Excel can do this. You should use someVBA codesfor this. Below, I am attaching these codes.–>In theModule 1write the following code. Which will return theSumof selected cells.–>In theModule 2write the following code. Which will return theAverageof selected cells.–>In theModule 3write the following code. Which will return theMedianof selected cells.–>In theModule 4write the following code. Which will return thestandard deviationof selected cells.–>Finally, in theThisWorkbook>> write the following code.–>Now, save the code >> press onRunbutton >> close the Excel file >> re open the file >> select some cells >> right click >> from theContext Menu Bar.–>Then, choose the desire operation >> get the answer inMsgBox.