SUMIF Function

Excel SUMIF Function, is a powerful tool that is used to add up cell values based on certain conditions such as dates, numbers, and text. The syntax is =SUMIF(range, criteria, [sum_range]).

Excel SUMIF Function

SUMIF is a powerful function in excel that sums cell based on one condition or criteria. The condition or criteria can be based on dates, numbers, and text.

Excel SUMIF function supports logical operators:

• > Greater than
• < Smaller than
• <> Not-equal-to
• = Equal
• * ,? as wildcards

SUMIF function as the name suggests is formed by combining two functions: SUM and IF functions. SUMIF function is an Excel’s premade function. In this article, you will learn how to use the SUMIF function to, to sum up, values with the if condition in Excel.

SUMIF Syntax

• Range (required argument): The range of cells to compare or evaluated against the criteria.
• Criteria (required argument): The criteria or the condition that must be met.
• sum_range (optional): The range of cells containing the values to be summed. If omitted, then the values from range are summed.

Excel SUMIF Example

To better under SUMIF function, let’s consider this scenario. In this fictitious scenario, we want to find the total number of Assisted Living Residents in our locations (we have 3 locations in Tampa, Miami, and Jacksonville):

To write the SUMIF, follow these steps:

1. Type =SUMIF( to activate the function.