What is the SUMIF Function?
The SUMIF function is categorized under Excel Math và Trigonometry functionsFunctionsList of the most important Excel functions for financial analysts. This cheat sheet covers 100s of functions that are critical to know as an Excel analyst. It will sum up cells that meet the given criteria. The criteria are based on dates, numbers, và text. It supports logical operators such as (>, , =) & also wildcards (*, ?). This guide to the SUMIF Excel function will show you how to lớn use it, step-by-step.Bạn vẫn xem: Sumif function
As a financial analystFinancial Analyst Job DescriptionThe financial analyst job mô tả tìm kiếm below gives a typical example of all the skills, education, và experience required khổng lồ be hired for an analyst job at a bank, institution, or corporation. Perform financial forecasting, reporting, and operational metrics tracking, analyze financial data, create financial models, 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, & quantity are in column A, column B, and column C, respectively. In such a scenario, we can use the SUMIF function to lớn find out the sum of the amount related to a particular vegetable from a specific supplier.
Bạn đang xem: Cách dùng hàm sumif trong excel
=SUMIF(range, criteria, )
The formula uses the following arguments:Range (required argument) – This is the range of cells that we want khổng lồ apply the criteria against.Criteria (required argument) – This is the criteria which are used lớn determine which cells need to lớn be added.
When we provide the criteria argument, it can either be:
How khổng lồ use the SUMIF Excel Function
To understand the uses of the SUMIF function, let’s consider a few examples:Example 1
Suppose we are given the following data:
We wish khổng lồ find total sales for the East region và the total sales for February. The formula to use to lớn 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#VALUE! error – Occurs when the criteria provided is a text string that is more than 255 characters long.When sum_range is omitted, the cells in range will be summed.The following wildcards can be used in text-related criteria:? – matches any single character* – matches any sequence of charactersTo find a literal question mark or asterisk, use a tilde (~) in frontof the question mark or asterisk (i.e. ~?, ~*).
Click here to download the sample Excel file
Thanks for reading CFI’s guide to lớn important Excel functions! By taking the time to lớn learn and master these functions, you’ll significantly speed up your financial analysis. Lớn learn more, check out these additional CFI resources: