SUMIF Text Excel (Table of Contents)
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 need to check criteria and then do the summation. Here we use SUMIF function with a wildcard which could be an asterisk (*) or question mark (?).
Syntax of the SUMIF with Text
SUMIF ()– It will return the summation for given data in some criteria.
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 the Sum_range, then it will do summation for 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.
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 the Delhi city.
Step 1: Open MS Excel, Go to Sheet1 where the user wants to calculate the total sold amount only from the Delhi city.
Step 2: Create one header for the SUMIF results to show the function result in the C column.
Step 3: Click on cell C2 and apply the SUMIF Function.
4.8 (3,103 ratings)
View Course
Step 4: Now it will ask for the range which will be for criteria range, select from cell B2 to B10.
Step 5: Now it will ask for criteria which is Delhi, as the user wants to calculate sold amount from the Delhi only.
Step 6: Now it will ask for the sum range which the user wants to add, select cell A2 to A10.
Step 7: Press the Enter Key.
Summary of Example 1: As the user wants to calculate the total sold amount only from the 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.
Step 2: Create one header for the SUMIF results to show the function result in column C.
Step 3: Click on cell C2 and apply the SUMIF Function.
Step 4: Now it will ask for the range which will be for criteria range, select cell A2 to A10.
Step 5: Now it will ask for criteria that the user wants to calculate only for M size products.
Step 6: Now it will ask for the sum range which the user wants to add, select cell B2 to B10.
Step 7: Press the Enter key.
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 the 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.
Step 2: Create one header for the SUMIF results to show the function result in the D column.
Step 3: Click on the D2 cell and apply SUMIF Function.
Step 4: Now it will ask for the range which will be for criteria range, select the A2 to A10 cell.
Step 5: Now it will ask for criteria which is the user wants to calculate only for the T-shirt products.
Step 6: Now it will ask for the sum range which the user want to add, select C2 to C10 cell.
Step 7: Press Enter key.
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 price 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 for numeric criteria, it is not necessary to give double quotations.
- Here we use 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 downloadable excel template. You can also go through our other suggested articles –
