Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

How to SUM in Excel

he SUM function in Excel is one of the most widely used arithmetic functions. The SUM Excel function adds numbers in rows, columns, cell references, ranges, arrays, and constants. In case you might be wondering how to how to sum cells in excel. You need to specify the cells to be added inside the SUM function to get the sum.

How to SUM in Excel

Syntax of the function

As the SUM definition suggests, the syntax for SUM function in Excel is:

=SUM (number1, [number2], [number3], ...)

OR

=SUM (cell1:cell2, [cell3:cell4], ... )

Arguments

number

The first argument is required. The others are optional. A numeric value you want to sum. It can be a number, cell reference, array or constant. E.G. SUM(23,3); SUM(A1,B32,B2) etc.

cell

The first argument is required. The others are optional. The cell ranges you want to sum. E.G., =SUM(A1:A34), etc.

Notes

  • The SUM function can have up to 255 arguments.
  • When using SUM as =SUM(number1, [number2], [number3], …) and you have entered a non-numeric content in place of num, SUM will produce a #Name? error.
  • However, when using SUM as =SUM(cell1:cell2, [cell3:cell4], …  ) if any of the cell range contains a non-numeric content, SUM function will ignore this value.
  • Sum is not a dynamic function. If you have applied Sum to a range of cells and filtered some values, the output of the Sum function won’t change. SUM does not change its result according to the current values in the filter. In these cases, it is best to use the SUBTOTAL function.

How to Sum a Column in Excel

In the following example, you have the monthly bills in column A. To sum the bills and have the result in cell B7, you need to add the bills as an argument to the SUM function.

  1. Select cell B7 clicking on it with your mouse.
  2. Assign the formula =SUM(B2:B6) to cell B7. You can also type =SUM( and select the range B2:B6 by clicking on B2 and dragging it all the way to B6.
  3. Click Enter to apply the formula to cell B7.

Cell B7 will now the values for the entries in column A and show the total of bills.

How to Sum Columns in Excel

You can sum multiple columns following the same principles. In the following example, you have the monthly sales for the first quarter. To find the total sales:

  1. Select cell D6.
  2. Assign the formula =SUM(B2:B5,C2:C5,D2:D5) to cell D6. Like the previous example, you can select and drag the range B2 to D5 with your mouse.
  3. Click Enter.

Cell D6 will now have the total sales for the quarter.

How to Sum Multiple Rows in Excel

You can sum multiple rows adding them as arguments to SUM. If the previous example was transposed to have the monthly sales as rows, to find the total sales for the quarter:

  1. Select cell E7 by clicking on it.
  2. Assign the formula =SUM(B2:E2,B3:E3,B4:E4) to cell E7. You can also select and drag the range.
  3. Click Enter. It will apply the formula above to cell E7.

E7 will add the rows containing the sales. Finally, it will show the total sales for the quarter, which is $55,350.

Still need some help with Excel formatting or have other questions about Excel? Connect with a live Excel expert here for some 1 on 1 help. Your first session is always free. 

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Solution examples
I need a formula to pop at the upper left corner of a spreadsheet. If I enter the month "January," I want the column number sum of January =SUM(AB11:AB75) from another section on the same excel page to pop right below the "January" cell, and not display the formula expression, but see the $100.
Solved by T. Q. in 40 mins
Can't add (SUM) in imported numbers from bank account
Solved by F. C. in 40 mins
I need a formula that will check if 2 or more cells containing names match then add the adjacent cells to matching name together.
Solved by F. D. in 59 mins
I need a formula to combine D2 to D100 to add together a column of numbers, then take away the same amount on the same row when column E is filled. i.e. column D is a price of an item, so the formula must calculate the total, then when the item is sold an 'a' is marked next to the item in column E, the formula then must deduct this amount from the total
Solved by X. W. in 20 mins
I would like to have a diagram in a new sheet, where the horizontal axis is the days, as they are in column DX. Each day shall show the sum of all unique leads of that day, and I would like to be able to check via a box of checkboxes, which facilities are shown, the facilities are in column BC.
Solved by I. A. in 45 mins

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc