You can also refer to C2 instead of typing the text criteria manually. You can also write it as either 'RETAIL' or 'Retail', and the total will be the same.

Notice that the text is enclosed within double quotes and not case-sensitive. The formula sums the amounts in column G (range G6:G20), where the order type in column D (D6:D20) is equal to 'retail'. In the following example, we are calculating the total for Retail orders using a SUMIF formula in C3:įormula explanation: =SUMIF(D6:D20,'retail',G6:G20) Excel SUMIF: If cells match specific text Now, let’s see some examples of using the Excel SUMIF function to solve simple cases, such as summing if cells match specific text, if cells are empty, etc. It’s a powerful data integration tool that lets you bring data from external sources into Excel, Google Sheets, and BigQuery for your analysis needs! Explore Microsoft Excel integration, as well as how Coupler.io works and reasons you would need Excel integration for your business. Tip: If you have data stored in PipeDrive, Shopify, Jira, or other external sources but want to do an analysis using Excel, you can import them first into Excel using Coupler.io. As you can see, each order has an order number, order type, customer info and the product they ordered, total order value in USD, and notes related to that particular order. We’ll use the following order data for most of the examples used in this article. Basic Examples of Excel SUMIF function with text criteria

If you want to learn about the basics of SUMIF, check out our article on that: SUMIF function in Excel. If you want to find the sum of values with multiple criteria, use the SUMIFS function instead.Īlso, keep in mind that you can also use SUMIF with dates or numbers in the criteria other than text.You can use the text criteria with wildcards ( *, ?, ~) for partial matching.However, you can omit the “ =” operator when using “is equal to” criteria. You can use logical operators ( =, >, >=, ) combined with text criteria.The length of the text criteria is limited to 255 characters.The text criteria is not case-sensitive.If you don’t specify this argument, Excel adds the cells specified in the criteria_range argument. 'text_criteria': Text criteria, enclosed in double quotes.criteria_range: The range of cells that contains the criteria.To use SUMIF with text criteria, you can use the following general formula: =SUMIF(criteria_range, 'text_criteria', ) SUMIF allows you to sum numbers based on criteria. Wrapping up How to use SUMIF with text criteria in Excel

Use quick analysis tool in excel to sum