Excel SUMIF | SUMIFS | SUM function - Technology & Tools

Watch Video - Excel Formula Tutorial | All Excel Tutorial Videos

Summary - The Excel SUMIF function returns the sum of cells that meet a single condition. Criteria can be applied to dates, numbers, and text. The SUMIF function supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.

Purpose - Sum numbers in a range that meet supplied criteria

Return value - The sum of values supplied.

Syntax - =SUMIF (range, criteria, [sum_range])

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] The cells to add together. If sum_range is omitted, the cells in range are added together instead.

Watch Video - Excel Formula Tutorial | All Excel Tutorial Videos

Hi Babita, here's a clear summary of the Excel SUM, SUMIF, and SUMIFS functions, with examples for your quick reference:

✅ 1. SUM Function

Purpose: Add a range of numbers.

📌 Syntax:

🧮 Example:

Adds all values in cells A1 through A5.

✅ 2. SUMIF Function

Purpose: Adds values based on one condition.

📌 Syntax:

range – Range to evaluate for the condition
criteria – Condition (e.g., ">100", "Pen", ">=01-01-2024")
sum_range – Actual cells to sum (optional, defaults to range)

🧮 Example:

Adds values in B2:B10 where A2:A10 > 100

✅ 3. SUMIFS Function

Purpose: Adds values based on multiple conditions.

📌 Syntax:

🧮 Example:

Adds values in C2:C10 where:

A2:A10 = "North"
B2:B10 > 1000

✅ Wildcards You Can Use (Text Criteria):

* → Matches any number of characters
? → Matches a single character

🧮 Example:

Sums B2:B10 where A2:A10 starts with "Pen" (e.g., "Pen", "Pencil")

Menu