Excel allows us to sum all values from a table that equal to the selected value by using the **SUMIF** function. This step by step tutorial will assist all levels of Excel users in summing values from the table with a certain condition.

*Figure 1. The final result of the SUMIF function*

**Syntax of the SUMIF formula**

**=SUMIF(range, criteria, sum_range)**

The parameters of the SUMIF function are:

**range**– a range of cells which we want to evaluate**criteria**– criteria for summing data**sum_range**– a range of cells that we want to sum if a condition is met

**Setting up Our Data for the SUMIF Function**

Our table consists of 3 columns: “Delivery Number” (column B), “Delivery Date” (column C) and “Amount” (column D). In cell G2, we specify a date for which we want to sum the amounts. In the cell G3, we want to get a sum of all amounts where a date from the column D is equal to the date in the cell G2.

* Figure 2. Data that we will use in the SUMIF example*

**Sum Amount if Cells are Equal to the Condition**

We want to sum all amounts from column D that have appropriate date equal to 1-Oct-18.

The formula looks like:

**=SUMIF(C3:C9, G2, D3:D9)**

The **range** is C3:C9, while the **criteria** is G2. The **sum_range** is D3:D9.

To apply the SUMIFS function, we need to follow these steps:

- Select cell G3 and click on it
- Insert the formula:
`=SUMIF(C3:C9,G2,D3:D9)`

- Press enter

*Figure 3. Using the SUMIF function to sum values greater than the limit*

We see in this example that the formula sums all the amounts that have date 1-Oct-18 in the table. As you can see, rows 3($1,000) and 9($500) meet the condition, so corresponding amounts are summed. Finally, the sum in the cell G3 is $1,500.

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