What is SUMIF formula in Excel?
The SUMIF formula is a useful function in Excel that is used to find the total sum of cells based on particular criteria. This formula is useful when you want to sum only those data rows that meet a particular condition or criteria.
Formula -
=SUMIF(range, criteria, [sum_range])
- range: This is the range of cells in which you want to look for the criteria. It can be a column or a row.
- criteria: This is the criteria on which you want to filter the data. The criteria can be a specific value (such as "Vegetarian"), a text (such as "Misal Pav"), or a number (such as ">100").
- [sum_range] (optional): This is the range of cells for which you want to calculate the sum. If you omit this argument, Excel adds the values matching the criteria in the "range" itself.
Table of Contents
Use of SUMIF Formula: Understand with an Example
The SUMIF formula in Excel is a very useful tool that lets you calculate the total sum of cells based on a certain criterion. In this article, we will look at using the =SUMIF formula through an example.
Example -
We have a data table that has the following columns:
Using the SUMIF Formula
Now, we will use the SUMIF formula to analyze this data.
Calculate the total cost for Misal Pav
We need to find the total price of the food item named "Misal Pav". For this, we will use the following SUMIF formula:
=SUMIF(B2:B15, "Misal Pav", C2:C15)
Here:
- B2:B15 is the range that contains the information of the food item named "Food".
- "Misal Pav" is the criteria for which we need to find the total price.
- C2:C15 is the range that contains the prices of the food items.
Applying this formula we get:
Food: Misal Pav | Total Price: 400
Calculating the Total Cost for Vegetarian Food Type
Now we will calculate the total price of all the food items of the food type "Vegetarian". For this we will use the following SUMIF formula:
=SUMIF(A2:A15, "Vegetarian", C2:C15)
Here:
- A2:A15 is the range containing the "Food Type" information.
- "Vegetarian" is the criteria for which the total value is to be calculated.
- C2:C15 is the range containing the prices of the food items.
Applying this formula we get:
Food Type: Vegetarian | Total Price: 1730
Conclusion
The SUMIF formula is a powerful and versatile function that helps summarize data based on a particular criterion. It is especially useful for tasks such as financial analysis, budget management, and data analysis.
0 Comments