PK !q@= = [Content_Types].xmlPK ! PK !) docProps/core.xmlSUMIFS Practice WorkbookXplorExcel.comFree SUMIFS practice sheets with answer key — https://xplorexcel.com/sumifs-formula-in-excel/PK !0 docProps/app.xmlXplorExcel Practice BuilderPK ! xl/workbook.xmlPK !h h xl/_rels/workbook.xml.relsPK !bI
xl/styles.xmlPK !#Vu u xl/worksheets/sheet1.xml0
1
23
45
|
6
78
910
1112
1314
|
15
1617
1819
2021
|
2223
PK !F # xl/worksheets/_rels/sheet1.xml.relsPK ! p p xl/worksheets/sheet2.xml24
2526272829
30313665D4*E4
323362185D5*E5
34354365D6*E6
363117120D7*E7
37335795D8*E8
38351090D9*E9
39
40
41
42
43
PK !<'6 xl/worksheets/sheet3.xml4445
2526272829464748
30313665D4*E4149
323362185D5*E5250
34354365D6*E6351
363117120D7*E7452
37335795D8*E8
38351090D9*E953
543153175D10*E10
553342100D11*E11
56356735D12*E12
57317420D13*E13
58332150D14*E14
593533150D15*E15
603121195D16*E16
613348160D17*E17
62355440D18*E18
63311230D19*E19
64333585D20*E20
653529135D21*E21
PK !\ \ xl/worksheets/sheet4.xml6645
26676869464748
3117071
3327271
3537371
474
53
PK !z% % xl/worksheets/sheet5.xml13
75
7646477778
91497919590
9250806
9351813265
945282265
11170836
112728419590
11373853265
114748669445
PK ! Q{ xl/sharedStrings.xmlSUMIFS — Practice WorkbookXplorExcel.com · free Excel tutorials and practice filesLessonSUMIFS Function in ExcelAll Excel lessonshttps://xplorexcel.com/excel-tutorial/What’s insideIllustrationA fully worked example. Click any cell to see the formula.Practice Sheet 1A category log. Answer one condition at a time.Practice Sheet 2A summary block. One formula, copied down, doing every category at once.Answer KeyEvery answer plus the exact formula that produces it.How to use it1Read the lesson first, then open the Illustration sheet.2Work through each Practice Sheet. Type formulas into the shaded cells.3Only then open the Answer Key. Compare your formula, not just your number.LicenceFree to use and share for personal study and classroom teaching. Please link back rather than re-hosting the file.Greenfield Academy — sales by category, worked exampleDateCategoryQuantityRateAmount2026-04-01Class 92026-04-02Class 102026-04-03Class 112026-04-042026-04-052026-04-06What is happening here• SUMIF adds only the rows that match a condition. =SUMIF(C4:C9,"Class 9",F4:F9) adds the Amount for Class 9 rows and ignores the rest.• The three parts are the range to test, the condition, and the range to add. Get the last one wrong and you silently total the wrong column.• COUNTIF takes only the first two — it counts matching rows rather than adding a second column.• A text condition sits in double quotes. The two ranges must be the same height or the answer quietly shifts.Greenfield Academy — category salesSolve the following with the help of the SUMIFS formula.#QuestionYour AnswerWhat is the total Amount for Class 9?How many rows are Class 10?What is the average Amount of a Class 9 row?Total the Quantity for Class 10 — same condition, a different range to add.Type your formula in the shaded cells. Check yourself on the Answer Key sheet.2026-04-072026-04-082026-04-092026-04-102026-04-112026-04-122026-04-132026-04-142026-04-152026-04-162026-04-172026-04-18Greenfield Academy — summary by categoryRowsTotal AmountAverage AmountFill the Rows column by pointing the condition at the Category cell beside it.→ fill in the tableFill Total Amount the same way, adding from Practice Sheet 1.Fill Average Amount for each category.Do the three category totals add up to the total of every row?Try every question before you read this. Compare the formula, not only the result.SheetFormula to useAnswer=SUMIF(C4:C21,"Class 9",F4:F21)=COUNTIF(C4:C21,"Class 10")=AVERAGEIF(C4:C21,"Class 9",F4:F21)=SUMIF(C4:C21,"Class 10",D4:D21) ← only the third argument changes=COUNTIF('Practice Sheet 1'!C4:C21,B4) ← condition = the cell, not typed text=SUMIF('Practice Sheet 1'!C4:C21,B4,'Practice Sheet 1'!F4:F21) ← then copy down=AVERAGEIF('Practice Sheet 1'!C4:C21,B4,'Practice Sheet 1'!F4:F21)=SUM('Practice Sheet 1'!F4:F21) ← compare it against your Total Amount columnPK !q@= = [Content_Types].xmlPK !