SUMIF & SUMIFS

SUMIF and SUMIFS formulae are formed by combining SUM and IF Functions. 

​The SUM function has the capability to add items, and SUMIF function extends the capabilities of SUM function by giving you the choice to SUM only those items that meet a particular criteria.

SUMIF Function:

=SUMIF(range, criteria [, sum_range])

• ‘range’ refers to the cells that you want to be evaluated by the ‘criteria’.
• ‘criteria’ refers to the condition that specifies which items are to be added. ‘criteria’ can be a number, expression or a text string.
• ‘sum_range’ is an optional argument, it specifies the cells to be added. If ‘sum_range’ argument is omitted then SUMIF treats ‘range’ as ‘sum_range’.

SUMIFS Function:

=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

• ‘sum_range’ specifies the cells that are to be added based on the given conditions. It is a required field.
• ‘criteria_range1’ specifies the first range where the first criteria is to be evaluated.
• ‘criteria1’ specifies the condition that is to be evaluated in the ‘criteria_range1’.
• ‘criteria_range2’, ‘criteria2’ specifies the other ranges and their respective conditions. It is an optional argument. SUMIFS supports a total of 127 range criteria pairs.

Support Link: ​http://www.exceltrick.com/formulas_macros/excel-sumif-and-sumifs/

Practice Task File

sumif-exercises_student.xlsx
File Size:	9 kb
File Type:	xlsx

Download File

---

1) Sum of refrigerator items
2) Sum of washing machine items
3) Sum of items transported by truck 4
4) Sum of items transported by trucks
Note: I have already setup a table for you to place the answers on the spreadsheet file