How to Add Multiple Cells in Excel (6 Methods)

There are a few quick ways to add multiple cells in Excel. Today we are going to learn how to use them with numerous techniques and formulas.


Practice Workbook

Download the following workbook and exercise.


6 Methods To Add Multiple Cells in Excel

1. Use AutoSum Feature to Add Multiple Cells

The easiest way to add multiple cells is using the AutoSum feature. By clicking the AutoSum, Excel automatically adds multiple cells by entering the SUM function. Suppose we have a table of people’s names and their working days.

Use AutoSum Feature to Add Multiple Cells

Now we are going to add the total working days.

Steps:

  • First, click Cell C10.
  • Then go to the Home tab.
  • Next from the Editing group of commands, click on the AutoSum.

Use AutoSum Feature to Add Multiple Cells

  • In Cell C10, a formula appears and points to the cells we want to add.

Use AutoSum Feature to Add Multiple Cells

  • Hit Enter.
  • Now the result is showing in the required cell.

NOTE:

We can also find the AutoSum from the Formulas tab. Formulas > AutoSum.

Read More: How to Add Specific Cells in Excel (5 Simple Ways)


2. Apply Algebraic Sum to Add Multiple Cells

Let’s say we have a worksheet. It contains all the employee’s salaries. Now we are going to add simply all the salary cells to get the total salary in Cell C10.

Apply Algebraic Sum to Add Multiple Cells

Steps:

  • First, select Cell C10 and type the Equal (=) sign.
  • Click on the first cell to add and type the Plus (+) sign.
  • Now click on the second cell and repeat till all the cells add up.

Apply Algebraic Sum to Add Multiple Cells

  • Finally, hit Enter and the total amount is showing in Cell C10.

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


3. Add Cells Using SUM Function

The SUM function is one of the most simple ways to add multiple cells in Excel easily.

  • Type “=SUM(“ in Cell C10.
  • Now we can manually input the data by using a comma for each.

Add Cells Using SUM Function

Or by clicking and dragging data cells that contain values we want to add.

Add Cells Using SUM Function

  • After hitting the Enter, we can easily find the required result.

Add Cells Using SUM Function

NOTE:

We can also find the SUM formula from the toolbar,

From Home > SUM

Or in Formulas > SUM

Read More: Shortcut for Sum in Excel (2 Quick Tricks)


Similar Readings


4. SUMIF Function to Add Up Cells with Condition in Excel

To add up the cells that meet certain criteria we can use the SUMIF function. Let’s say we have a worksheet with some random names of employees, their sales quantity, and the sales amount. Now we are going to add up the sales amount where the quantity is less than a certain number and the sales amount that are also less than a certain number.

SUMIF Function to Add Up Cells with Condition in Excel

STEP 1:

  • Click on cell C10
  • Next type the formula:
=SUMIF(C5:C9,"<5",D5:D9)

Here the SUMIF function goes through the C column. If the criteria match then it will add up the matched data of column D.

SUMIF Function to Add Up Cells with Condition in Excel

  • Hit Enter to see the added values on cell C10.

SUMIF Function to Add Up Cells with Condition in Excel

STEP 2:

  • Click on cell D10.
  • Then write the formula
=SUMIF(D5:D9,"<6000")

Here the SUMIF function goes through column D to find the data which matches certain criteria.

  • Hit Enter for seeing the added values on cell D10.

Read More: Excel Sum If a Cell Contains Criteria (5 Examples)


5. Add Multiple Cells Together Containing Text in Excel

By using CONCATENATE function or Ampersand (&), we can add or join cells that contain text.

Let’s consider a worksheet containing text. We are going to add them.

Add Multiple Cells Together Containing Text in Excel

Steps:

  • Select Cell D5 at first.
  • Write the formula:
=CONCATENATE(B5,C5)

Add Multiple Cells Together Containing Text in Excel

  • Press Enter and the result is showing.

Add Multiple Cells Together Containing Text in Excel

  • Again select cell D6.
  • Write the formula:
=B6&""&C6

  • Finally, press Enter, and the result is displayed in the following screenshot.

Read More: Sum If a Cell Contains Text in Excel (6 Suitable Formulas)


6. Add the Same Number to Multiple Cells in Excel

We are going to add the value in cell E4 in multiple cells containing salary values.

Add the Same Number to Multiple Cells in Excel

Steps:

  • Select Cell E4 and copy it.
  • Now select the cells where we want to add the copied value.
  • Press Ctrl+Alt+V.
  • A dialogue box is showing.
  • From the Paste section select Values and in the Operation section select Add.
  • Click OK.

Add the Same Number to Multiple Cells in Excel

And we’ll get the resultant outputs as shown below.

Read More: How to Sum Columns in Excel (7 Methods)


Conclusion

These are the quickest way to add multiple cells in Excel. There is a practice workbook added. Go ahead and give it a try. Feel free to ask anything or suggest any new methods.


Related Readings

Nuraida Kashmin

Nuraida Kashmin

Hi Everyone! I am Nuraida. Cordially welcome you to my profile. I am a Team Leader of Excel and VBA Content Developer in ExcelDemy. Here I will also post articles related to Microsoft Excel. With a strong educational background in Mechanical Engineering through experimental learning from Rajshahi University of Engineering & Technology. Skilled in Microsoft Word, Creative Writing, Microsoft Excel, Project Management, Support to Organize Different Events, Reporting, Monitoring & Documentation, Online Advocacy and Event Management Related to SAP and Youth Leaders.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo