PK !q@= = [Content_Types].xmlPK ! PK !P docProps/core.xmlCOUNTIF Practice WorkbookXplorExcel.comFree COUNTIF practice sheets with answer key — https://xplorexcel.com/countif-excel-function/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 !e_ # xl/worksheets/_rels/sheet1.xml.relsPK !Ip p xl/worksheets/sheet2.xml24
2526272829
303124105D4*E4
323345110D5*E5
34356360D6*E6
36312160D7*E7
37336380D8*E8
38356125D9*E9
39
40
41
42
43
PK ! t4 xl/worksheets/sheet3.xml4445
2526272829464748
303124105D4*E4149
323345110D5*E5250
34356360D6*E6351
36312160D7*E7452
37336380D8*E8
38356125D9*E953
54317980D10*E10
553358200D11*E11
563569105D12*E12
57314140D13*E13
583327135D14*E14
593523155D15*E15
603141110D16*E16
613356185D17*E17
623563155D18*E18
63314750D19*E19
64332830D20*E20
653544185D21*E21
PK !\ \ xl/worksheets/sheet4.xml6645
26676869464748
3117071
3327271
3537371
474
53
PK ! % % xl/worksheets/sheet5.xml13
75
7646477778
91497918600
9250806
9351813100
945282277
11170836
112728418600
11373853100
114748688280
PK !Q xl/sharedStrings.xmlCOUNTIF — Practice WorkbookXplorExcel.com · free Excel tutorials and practice filesLessonCOUNTIF 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.Sunbeam Power Supply — sales by category, worked exampleDateCategoryQuantityRateAmount2026-06-01Domestic2026-06-02Commercial2026-06-03Agricultural2026-06-042026-06-052026-06-06What is happening here• SUMIF adds only the rows that match a condition. =SUMIF(C4:C9,"Domestic",F4:F9) adds the Amount for Domestic 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.Sunbeam Power Supply — category salesSolve the following with the help of the COUNTIF formula.#QuestionYour AnswerWhat is the total Amount for Domestic?How many rows are Commercial?What is the average Amount of a Domestic row?Total the Quantity for Commercial — same condition, a different range to add.Type your formula in the shaded cells. Check yourself on the Answer Key sheet.2026-06-072026-06-082026-06-092026-06-102026-06-112026-06-122026-06-132026-06-142026-06-152026-06-162026-06-172026-06-18Sunbeam Power Supply — 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,"Domestic",F4:F21)=COUNTIF(C4:C21,"Commercial")=AVERAGEIF(C4:C21,"Domestic",F4:F21)=SUMIF(C4:C21,"Commercial",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 !