SUMIFS practice exercises
Add up rows that meet several conditions at once, such as a region and a minimum amount. Note that the sum range comes first.
- 1SUMIFS with two conditionsIn E2, use SUMIFS to total the Sales of Shoes in the North region.
- 2SUMIFS with the conditions in cellsPremiumIn G2, use SUMIFS to total the Sales for the region in E2 and the product in F2. Point at the cells instead of typing the words.
- 3SUMIFS between two datesPremiumIn F3, total the amounts of the orders dated from F1 to F2, both days included. Give SUMIFS the date column twice: ">="&F1 and "<="&F2.
- 4SUMIFS that leaves one value outPremiumIn F1, total the North orders that were not returned. Give SUMIFS two conditions: the region "North" and the status "<>Returned".