This is the total amount spent on purchasing branded TVs. Hence, the sum of the values of cells C4, C7, and C10 is 1,73,000, shown in cell C14. In the succeeding table, the cells that satisfy the given criteria are C4, C7, and C10, which shows the prices of the branded TVs. We have to calculate the total amount spent on purchasing branded TVs using the SUMIF function. For some equipment, the brands are not specified. The following table shows a list of branded equipment and their prices. Total Amount Spent on Branded Televisions (TVs)
SUMIF FUNCTION IN EXCEL DOWNLOAD
You can download this SUMIF Function in Excel Template here – SUMIF Function in Excel Template Example #1 Each example covers a different case, implemented using the SUMIF function. Let us understand the SUMIF excel function with the help of the following examples. Note: If “sum_range” is not specified, the SUMIF function refers to the parameter “range” as the range of cells to be added. “Range” and “criteria” are the required parameters, whereas “sum_range” is an optional parameter. Sum_range: It indicates the range of cells to be added together.It determines the cells to be added from the given “sum_range.” Criteria: It refers to the conditions that are applied to the range of cells.Range: It refers to the range of cells on which the criteria is applied.The formula accepts the following arguments: The SUMIF function uses a single criterion, whereas the SUMIFS function uses multiple criteria. SUMIF function is categorized under the Excel Math and Trigonometry functions. Moreover, this function works similar to the SUMIFS function SUMIFS Function In Excel, SUMIFS is an in-built function that calculates the sum of all those cells which meet the multiple specified criteria & it is widely used as a conditional statement. For example, the formula “=SUMIF(B1:B5, “<=12”)” adds the values in the cell range B1:B5, which are less than or equal to 12.
![sumif function in excel sumif function in excel](https://www.automateexcel.com/excel/wp-content/uploads/2020/10/sum-if-year-Main-Function.jpg)
The criteria can include dates, numbers, and text.
![sumif function in excel sumif function in excel](https://www.techonthenet.com/excel/formulas/images/sumif001.png)
The SUMIF Excel function calculates the sum of a range of cells based on given criteria.