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.

## Leave a Comment