# How to use the Excel SUMIF Function

## Description

The SUMIF function is a worksheet function that adds all numbers in a range of cells based on one criteria (for example, is equal to 2000).

The SUMIF function is a built-in function in Excel that is categorized as a Math/Trig Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUMIF function can be entered as part of a formula in a cell of a worksheet.

To add numbers in a range based on multiple criteria, try the SUMIFS Function

### Syntax

The syntax for the SUMIF function in Microsoft Excel is:

`SUMIF( range, criteria, [sum_range] )`

### Parameters or Arguments

range

The range of cells that you want to apply the criteria against.

criteria

The criteria used to determine which cells to add.

sum_range

Optional. It is the range of cells to sum together. If this parameter is omitted, it uses range as the sum_range.

## Returns

The SUMIF function returns a numeric value.

Applies To

Excel for Office 365, Excel 2019, Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

Type of Function: Worksheet function (WS)

Example (as Worksheet Function)

Let’s explore how to use SUMIF as a worksheet function in Microsoft Excel.

Next, add the \$ sign by hitting on cell F4 so that it displays as below