To sum if cells contain specific text you can use the SUMIF function with a wildcard.
How to use sumif function in excel with text. The criteria are based on dates numbers and text. This cheat sheet covers 100s of functions that are critical to know as an Excel analyst. Step 3 The formula applied is.
The SUMIF function also known as Excel conditional sum is used to add cells based on a certain condition or criteria. The Excel SUMIF function returns the sum of cells that meet a single condition. Excel IF statement for blank non-blank cells.
It lets the user have the sum of values having criteria on the corresponding text values. To define the criteria this function supports logical operators and wildcard characters for partial matching. What is the SUMIF Function.
Once the range is picked give the comma as per syntax. Criteria can be applied to dates numbers and text. With the cell selected press the formula bar on the ribbon bar to focus on it.
Here the range is from B2 to B12 so select that range then the function will automatically pick B2B12 as shown in the above screenshot. If youve happened to read the COUNTIF tutorial on this blog you wont have any difficulties with understanding Excel SUMIF because its syntax and usage is analogous. For example suppose that in a column that contains numbers you want to sum only the values that are larger than 5.
Generic Excel SUMIF Formula. First select a cell where we want the results of the sum of X sales then apply the function and select the range. If you want to use the SUMIF function in an Excel workbook youll need to follow these steps.