Go Back

Excel SUM Function

We can use the EXCEL SUM FUNCTION to sum the value of specific cells. SUM FUNCTION sums values supplied as arguments (up to 255 arguments). Arguments are supplied as numbers, cell references, ranges, arrays, constants, and the results of other formulas or functions. The steps below will walk through the process.

Figure 1: How to use excel SUM Function

Syntax

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

Formula

=SUM(B4:B10)

Setting up the Data

We will set up the data as shown in figure 2. The data contains daily commissions for four weeks for an affiliate marketer.

Figure 2: Setting up the Data

Sum of Weekly Commissions

  • We will click on Cell B11
  • We will insert the formula below and press enter

=SUM(B4:B10)

Figure 3: Sum of Week 1 Commissions

  • We will click on Cell B11
  • We will use the fill handle (the small square box at the bottom right of the cell) to copy the formula to the other cells. Drag the fill handle along the row to Cell E11.

Figure 4: Sum of Weekly Commissions

Instant Connection to an Expert through our Excelchat Service

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

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

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

Need excel formula to add incremental columns in sum range when dragging down formulas. For example, SUM(A1:B1), SUM(A2:C2), SUM(A3:D3), etc.
Solved by D. W. in 14 mins
I am having a issue with a formula when trying to subtract a value from another in the formula it is subtracting the wrong amounts =IF(($A17-SUM($D17:J17))>0,IF((K$14-SUM(K$15:K16))<=($A17-SUM($D17:J17)),K$14-SUM(K$15:K16),(K$14-SUM(K$15:K16))-($A17-SUM($D17:J17))),0)
Solved by D. H. in 26 mins
Below is the formula I am working with =IF(SUM(C44:I45)>=40,SUM(C44:I44)-8,0)+IF(SUM(J44:P45)>=40,SUM(J44:P44)-8,0)+IF(SUM(Q44:V45,X44:X45)>40,SUM(Q44:V44,X44)-8,0) However, I'm not get the correct outcome. It is not considering if row 45 is less than 32.
Solved by T. B. in 16 mins

Leave a Comment

avatar