Sum up cells that meet the given criteria Show What is the SUMIF Function?The SUMIF Function[1] is categorized under Excel Math and Trigonometry functions. It will sum up cells that meet the given criteria. The criteria are based on dates, numbers, and text. It supports logical operators such as (>, <, <>, =) and also wildcards (*, ?). This guide to the SUMIF Excel function will show you how to use it, step-by-step. As a financial analyst, SUMIF is a frequently used function. Suppose we are given a table listing the consignments of vegetables from different suppliers. The names of the vegetable, names of suppliers, and quantity are in column A, column B, and column C, respectively. In such a scenario, we can use the SUMIF function to find out the sum of the amount related to a particular vegetable from a specific supplier. Formula=SUMIF(range, criteria, [sum_range]) The formula uses the following arguments:
When we provide the criteria argument, it can either be:
How to use the SUMIF Excel FunctionTo understand the uses of the SUMIF function, let’s consider a few examples: Example 1Suppose we are given the following data: We wish to find total sales for the East region and the total sales for February. The formula to use to get the total sales for East is: Text criteria, or criteria that includes math symbols, must be enclosed in double quotation marks (” “). We get the result below: The formula for total sales in February is: We get the result below: A few notes about the SUMIF Excel Function
Click here to download the sample Excel file Additional ResourcesThanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional CFI resources:
Article Sources
|