EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login
Home Excel Excel Resources Maths Function in Excel SUMIF with Text 
Secondary Sidebar
Excel Functions
  • Maths Function in Excel
    • Calculating Investment Return In Excel
    • Sumif Function Examples
    • MROUND in Excel
    • SUM Cells in Excel
    • MMULT in Excel
    • MINVERSE in Excel
    • Trunc in Excel
    • SUMIF with Text
    • COS Function in Excel
    • RANDBETWEEN in Excel
    • Excel SUMIF with OR
    • Excel DEGREES Function
    • Calculations in Excel
    • Sumif Between Two Dates
    • Calculate Income Tax in Excel
    • PRODUCT Function in Excel
    • How to Sum Multiple Rows in Excel
    • Matrix in Excel
    • ROUND Formula in Excel
    • How to SUM in Excel
    • SUMPRODUCT Formula in Excel
    • Excel Running Total
    • Excel Rounding
    • Excel Exponents
    • Excel SIN Function
    • Excel Square Root Function
    • Excel ROUNDUP Function
    • ROUND Excel Function
    • Excel ROUNDDOWN Function
    • ODD Excel Function
    • SUMPRODUCT Function in Excel
    • AGGREGATE Function in Excel
    • ABS Function in Excel
    • Excel TAN Function
    • COMBIN Function in Excel
    • CEILING Function in Excel
    • INT Excel Function
    • SUBTOTAL Function in Excel
    • LN Function in Excel
    • Excel RAND Function
    • TANH Function in Excel
    • SUMIF Function in Excel
    • SUM Function in Excel
    • POWER Function in Excel
    • EVEN Function in Excel
    • LOG Function in Excel
    • FLOOR Excel Function
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup and Reference Functions in Excel (36+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (24+)
  • Statistical Functions in Excel (59+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Excel Tips (220+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (22+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • Online EXCEL ADVANCED Certification
  • Excel for HR Training

SUMIF with Text 

By Arun GuptaArun Gupta

SUMIF with Text in Excel

SUMIF Text Excel (Table of Contents)

  • Introduction to SUMIF with Text
  • How to Use SUMIF with Text in Excel?

Introduction to SUMIF with Text

The SUMIF function is used to do summation for given data in some criteria, which need to be followed by the function to do a summation of the values. Like this, when there is some specific text, you need to check the criteria and then do the summation. Here we use the SUMIF function with a wildcard, which could be an asterisk (*) or question mark (?).

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

Syntax of the SUMIF with Text 

SUMIF ()– It will return the summation for given data in some criteria.

SUMIF Syntax

Arguments in the SUMIF Function:

  • range: It’s is a mandatory parameter where the user wants to apply the sum criteria.
  • criteria: It’s is a mandatory parameter, the condition for the sum which will determine cells to sum.
  • sum_range: It’s is an optional parameter, the cells that the user wants to add. If a user is not provided with the Sum_range, it will summarise the range cells.

How to Use SUMIF with Text in Excel?

Let’s understand how to use the SUMIF With Text with some examples. Let’s see how the SUMIF Function can solve this problem.

You can download this SUMIF with Text Excel Template here – SUMIF with Text Excel Template

Example #1

Basic SUMIF Function with TEXT in Excel

There are some sales data given in a table in Sheet1, so the user wants to calculate the total sold amount only from Delhi city.

Step 1: Open MS Excel, Go to Sheet1 where the user wants to calculate the total sold amount only from Delhi city.

SUMIF WITH Text Excel 1-1

Step 2: Create one header for the SUMIF results to show the function result in the C column.

SUMIF WITH Text Excel 1-3 

Step 3: Click on cell C2 and apply the SUMIF Function.

SUMIF WITH Text Excel 1-4

Step 4: Now, it will ask for the range which will be for the criteria range, select from cell B2 to B10.

SUMIF WITH Text Excel 1-5

Step 5: Now, it will ask for criteria which are Delhi, as the user wants to calculate sold amount from Delhi only.

SUMIF WITH Text Excel 1-6

Step 6: Now, it will ask for the sum range the user wants to add and select cell A2 to A10.

SUMIF WITH Text Excel 1-7

Step 7: Press the Enter Key.

SUMIF WITH Text Excel 1-8

Summary of Example 1: As the user wants to calculate the total sold amount only from Delhi city, which is coming as $72,038.40. It is the total sold amount from Delhi city only.

Example #2

Only for Single Letter

There are some sales data given in a table in Sheet2, so the user wants to calculate the total price money only for the M size products.

Step 1: Open MS Excel, Go to Sheet2 where the user wants to calculate total price money only for the M size products.

Single Letter Only in the Excel 2-1

Step 2: Create one header for the SUMIF results to show the function result in column C.

Single Letter Only in the Excel 2-2

Step 3: Click on cell C2 and apply the SUMIF Function.

Single Letter Only in the Excel 2-3

Step 4: Now, it will ask for the range for the criteria range and select cell A2 to A10.

Single Letter Only in the Excel 2-4

Step 5: Now, it will ask for criteria that the user wants to calculate only for M size products.

Single Letter Only in the Excel 2-5

Step 6: Now, it will ask for the sum range the user wants to add and select cell B2 to B10.

Single Letter Only in the Excel 2-6

Step 7: Press the Enter key.

Single Letter Only in the Excel 2-7

Summary of Example 2: As the user wants to calculate total price money only for the M size products. which is coming as $1,915.00. It is the total amount only for M size product.

Example #3

SUMIF Function with TEXT which is coming in between the Text String in Excel

There is some price data given in a table in Sheet3, so a user wants to calculate total price money only for the T-Shirt of any brand.

Step 1: Open the MS Excel; go to Sheet3, where the user wants to calculate total price money only for the T-Shirt of any brand.

Text String in Excel 3-1

Step 2: Create one header for the SUMIF results to show the function result in the D column.

Text String in Excel 3-2

Step 3: Click on the D2 cell and apply SUMIF Function.

Text String in Excel 3-3

Step 4: Now, it will ask for the range for the criteria range and select the A2 to A10 cell.

Text String in Excel 3-4

Step 5: Now, it will ask for criteria for the user to calculate only for the T-shirt products.

Text String in Excel 3-5

Step 6: Now, it will ask for the sum range the user wants to add and select C2 to C10 cell.

Text String in Excel 3-6

Step 7: Press Enter key.

Text String in Excel 3-7

Summary of Example 3: As the user wants to total price money only for the T-Shirt of any brand. which is coming as $5,797.50. It is the total prize money only for the T-Shirt of any brand.

Things to Remember About SUMIF With Text

  • Text criteria or a math symbol criteria must be enclosed in double quotation (“”), but it is not necessary for numeric criteria to give double quotations.
  • Here we use the SUMIF function with a wildcard which could be one of an asterisk (*) or question mark(?).
  • If the user has not provided the Sum_range, then it will do summation for the range cells.
  • It is an in-built function that comes under a Math/Trig Function category.

Recommended Articles

This is a guide to SUMIF with Text. Here we discuss How to use SUMIF with Text along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Methods to Insert Delta Symbol in Excel
  2. Examples on Sumif Between Two Dates
  3. MROUND in Excel | Formula, Example
  4. How to Use Checklist in Excel?
Popular Course in this category
Excel Advanced Training (16 Courses, 23+ Projects)
  16 Online Courses |  23 Hands-on Projects |  140+ Hours |  Verifiable Certificate of Completion
4.8
Price

View Course

Related Courses

Excel for HR Training (8 Courses, 10+ Projects)4.9
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

Download SUMIF with Text Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download SUMIF with Text Excel Template

EDUCBA

डाउनलोड SUMIF with Text Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more