SUMIF Function

---

Purpose of the Function

The Excel SUMIF function returns the sum of cells that meet a single condition.

Syntax

• range: The range of cells that you want to evaluate against the given criteria.
• criteria: The condition or criteria used to determine which cells to add. It can be a number, expression, or text that defines the condition for adding the corresponding cells in sum_range.
• sum range: Optional. The actual cells to sum if the criteria are met. If omitted, the range will be used for summation.

Practical Example

Step -01 : Call SUMIF Function:

Select the Cell, Which You Want to Apply the Function And Write SUMIF Function =SUMIF.

---

Step -02 : Enter SUMIF Arguments:

We need to select The Cells Which We Want to Returns the Sum Mark Value Based on The Single Condition within the Brackets. (Here Is Single Condition is Greater Than 90 in any MARK)

---

Step -03 : Hit The Enter Key :

After Entering the Function, We need hit The Enter Key, The Excel Retrieve the Sum Value Of Greater Than 90 in any MARK, Which We Selected Range.

---

Step -04 : Drag Or Double Click in the Plus Sign (+) :

If You Drag Your mouse In the Bottom of Right Corner in F2 Cell You Are Able To See Plus Sign (+), If you Double Click in The Plus Sign (+) The Excel Automatically Retrieve Entire Cells Sum Value Of Greater Than 90 Value in any MARK or Click On Plus Sign (+) And Drag Up to Last Cell..

---

SUMIF is beneficial for calculating totals based on specific conditions or criteria within a dataset, allowing you to extract and sum values that match particular criteria you specify.

• Previous
• Next

Advance Excel 365

---

Introduction to Microsoft Excel

---

• What is Excel 365
• Microsoft Excel
• Microsoft Excel Formulas and Functions

Mathematical Functions

---

• SUM Function
• AVERAGE Function
• MAX Function
• MIN Function
• ROUND Function
• SUMIF Function
• COUNT Function
• COUNTA Function
• COUNTIF Function

Date And Time Functions

---

• NOW Function
• TODAY Function
• YEAR Function
• MONTH Function
• DAY Function
• HOUR Function
• MINUTE Function
• SECOND Function
• TIME Function

Text Functions

---

• CONCATENATE Functions
• LEN and MID Function
• TRIM Function
• TEXT Function
• LEFT Function
• RIGHT Function
• UPPER Function
• LOWER Function
• PROPER Function
• REPT Function
• EXACT Function

Logical Functions

---

• IF Function
• VLOOKUP Function