PK !q@= = [Content_Types].xmlPK ! PK ! docProps/core.xmlSUM Practice WorkbookXplorExcel.comFree SUM practice sheets with answer key — https://xplorexcel.com/sum-function-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 !3
# xl/worksheets/_rels/sheet1.xml.relsPK !1vr r xl/worksheets/sheet2.xml24
2526272829
303152260D4*E4
323342230D5*E5
34352355D6*E6
363756125D7*E7
38395390D8*E8
403114260D9*E9
41
42
43
44
45
PK !>ֆ xl/worksheets/sheet3.xml4647
2526272829484950
303152260D4*E4151
323342230D5*E5252
34352355D6*E6353
363756125D7*E7454
38395390D8*E8
403114260D9*E955
563316230D10*E10
57351255D11*E11
583710125D12*E12
59393390D13*E13
603128260D14*E14
613333230D15*E15
62352955D16*E16
633728125D17*E17
PK !w\"T T xl/worksheets/sheet4.xml6447
2665666768484950
3153796716970
33703179271
35638885372
37267254473
39665048
55
PK !% % xl/worksheets/sheet5.xml13
74
7548497677
915178429
92527968380
93538043535
94548163500
1116982199
1127183278
1137284931
11473855
PK !Rw& & xl/sharedStrings.xmlSUM — Practice WorkbookXplorExcel.com · free Excel tutorials and practice filesLessonSUM 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 daily log. The totals are gone — you write them.Practice Sheet 2A grid instead of a log. Total across and down.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.IronWorks Fitness — daily sales, worked exampleDateItemQuantityRateAmount2026-04-01Yoga2026-04-02Cardio2026-04-03Personal Training2026-04-04Zumba2026-04-05Weights2026-04-06What is happening here• SUM adds every number in the range you give it. =SUM(F4:F9) adds the whole Amount column at once.• The colon in F4:F9 means everything from F4 down to F9. Insert a row inside that range and the total follows.• SUM skips text and blanks, so a stray label will not break it — but a number typed as text is skipped silently, which is why a total can look too low.• Amount is Quantity x Rate row by row, then SUM adds that column. Two simple steps beat one clever formula.IronWorks Fitness — daily salesSolve the following with the help of the SUM formula.#QuestionYour AnswerWhat is the total quantity sold over the whole period?What is the total value of everything sold?What is the total value of the first seven days only?In one formula, add the first seven days and the last four, skipping the middle.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-14IronWorks Fitness — units by weekWeek 1Week 2Week 3Item TotalFill the Item Total column — how many units of each item across the three weeks?→ fill in the tableWhat was the total for Week 1 across every item?What is the grand total — every item, every week?How many rows of data are there? Count the Week 1 figures.Try every question before you read this. Compare the formula, not only the result.SheetFormula to useAnswer=SUM(D4:D17)=SUM(F4:F17)=SUM(F4:F10)=SUM(F4:F10,F14:F17) ← a comma joins two ranges in one SUM=SUM(C4:E4) ← then copy down=SUM(C4:C8)=SUM(C4:E8)=COUNT(C4:C8) ← COUNT counts numbers, not labelsPK !q@= = [Content_Types].xmlPK ! ֆ vA xl/worksheets/sheet3.xmlPK !w\"T T S xl/worksheets/sheet4.xmlPK !% % S_ xl/worksheets/sheet5.xmlPK !Rw& & k xl/sharedStrings.xmlPK