How to use the Excel SUMIF Function
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
The syntax for the SUMIF function in Microsoft Excel is:
SUMIF( range, criteria, [sum_range] )
Parameters or Arguments
The range of cells that you want to apply the criteria against.
The criteria used to determine which cells to add.
Optional. It is the range of cells to sum together. If this parameter is omitted, it uses range as the sum_range.
The SUMIF function returns a numeric value.
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
Excel SUMIF Function
Send download link to: