Excel SUMIF | SUMIFS | SUM function

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

Replies (1)

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:

 
=SUM(number1, [number2], ...)

๐Ÿงฎ Example:

 
=SUM(A1:A5)

Adds all values in cells A1 through A5.


โœ… 2. SUMIF Function

Purpose: Adds values based on one condition.

๐Ÿ“Œ Syntax:

 
=SUMIF(range, criteria, [sum_range])
  • 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:

 
=SUMIF(A2:A10, ">100", B2:B10)

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


โœ… 3. SUMIFS Function

Purpose: Adds values based on multiple conditions.

๐Ÿ“Œ Syntax:

 
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

๐Ÿงฎ Example:

 
=SUMIFS(C2:C10, A2:A10, "North", B2:B10, ">1000")

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:

 
=SUMIF(A2:A10, "Pen*", B2:B10)

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


Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 18 November 2026
Articled Assistant

A.Singhi & Co

Kolkata

CA Inter

View Details
Company
20 November 2026
Senior Accountant

Compass Tex India Pvt Ltd

Coimbatore

CA Inter

View Details
Company
16 November 2026
Indirect Tax Associate

Sekhri Kanodia & Associates

Mumbai

B.Com

View Details
Company
ARTICLESHIP 07 November 2026
Article Assisstant

DPV & Associates

Chennai

CA Inter

View Details
Company
28 October 2026
Assistant Director/ Associate Director-Finance & Accounting

Krea University

Chennai

CA

View Details
Company
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details
Company
Featured 29 October 2026
Accounts Executive

Synergy Keystone

Chennai

B.Com

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details