SUMIF Function Quick Steps

This Excel tutorial explains how to use the Excel SUMIF function step-by-step with syntax and examples, works very fast.

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.

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

Example (as Worksheet Function)

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

How to use : 

1.  Put '=' sign before entering the fomula.
2. Type "SUMIF", press tab to get ( sign or alternatively you can type it.
3. Select the total range (in above picture B & C Column)
4. Put a comma and type / select for what you want to calculate the sum.
5. Put a comma and select the range ((in above picture "C" Column)
6. And you are done.

For any question please comment.