Menu
EXCEL SUMIF FUNCTION
Excel SUMIF Function Introduction
The SUMIF function belongs to the Math and Trigonometry category. It will total the cells that satisfy the specified conditions. Dates, numbers, and text are used as criterion. It accepts logical operators (>, >, =) as well as wildcards (*,?). This SumIf Excel function tutorial will show you how to utilise it step by step. SUMIF is a widely used function as a financial analyst. Assume we are provided a table containing the consignments of veggies from several vendors. Columns A, B, and C include the names of the vegetables, the names of the providers, and the amount. In such a case, we may use the SUMIF function to calculate the total of the amounts associated with a given variable.
Description of Excel SUMIF Function
Snytax:
=SUMIF(range, criteria, [sum_range])
Parameter list:
The following factors are used in the formula:
1. Range (mandatory argument) – This is the range of cells against which we wish to apply the criterion.
2. Criteria (mandatory argument) – The criteria are used to decide which cells must be added. When we provide the criterion argument, it might be one of two things: • A numeric value (e.g., 10, 01/01/2018, TRUE) or • A text string (e.g., “Text”, “Thursday”) or • An e.g., “>12”, “>0”).
3. Sum range (optional parameter) – This is an array of numeric values (or cells holding numeric values) that will be added together if the relevant range item meets the specified conditions. If the [sum range] parameter is not specified, the values in the range argument are summed instead.
Step By Step Guide of SUMIF Function
Example :
The formula for total sales in February is as follows:
Key Points
1. #WORTH! Error – Occurs when the given criterion is a text string that is longer than 255 characters.
2. If sum range is not specified, the cells in range are totaled.
3. In text-related criteria, the following wildcards can be used:
•? – corresponds to any single character
• * – matches any character sequence
4. To find a literal question or exclamation, place a tilde () before the question mark or underscore (i.e.?, *).
Excel SUMIF Function Template/Exercise
- Download SUMIF Function Template
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
