Free Excel template · Excel for teachers

Free Excel missing assignments tracker

Q: Should a missing assignment count as zero?

That is your grading policy, not an Excel rule. This template counts missing work as zero in % earned and leaves excused (EX) work out completely. If your school uses a minimum score, type it in instead of leaving the cell empty.

Q: Why does the Who is missing it row show #NAME?

Your Excel version does not have FILTER (Excel 2019 and older). The Missing count in column H, Points earned and % earned work in every version; delete row 17 or upgrade to use the name lists.

For teachers who need to know, at any moment, who is missing what. Enter scores as they come in and leave missing work empty; the template counts each student's missing assignments that are already due, lists who has not turned in each assignment, and works out the share of points earned so far. Type EX for excused work and it is not counted as missing or as points possible.

cellwise-missing-assignments-tracker-template.xlsxExcel workbook · 4.8 KB · works in Excel, Google Sheets, Numbers and LibreOffice · no signup

Download free template

Preview and try it

This is the template's sheet, calculated by the same engine as the Cellwise app. Change any number to see the formulas react before you download.

	A	B	C	D	E	F	G	H	I	J	K
1	Student	Lab 1	HW 5	Quiz 3	Essay	HW 6	Lab 2	Missing	Points earned	Points possible	% earned
2	Due date	Oct 20, 2026	Oct 23, 2026	Oct 28, 2026	Nov 3, 2026	Nov 6, 2026	Nov 12, 2026
3	Points	20	10	25	50	10	20
4	Maya	19	10	23	47	9	18	0	108	115	0.939
5	Leo	15		18	38			2	71	115	0.617
6	Priya	20	9	25	49	10		0	113	115	0.983
7	Omar		7	16		6		2	29	115	0.252
8	Jonah	12			30			3	42	115	0.365
9	Sofia	18	8	21	EX	9		0	56	65	0.862
10	Eli	16	6	19	41			1	82	115	0.713
11	Nora	20	10	24	50	10	19	0	114	115	0.991
12
13	Count work due on or before	Nov 6, 2026
14	Turned in	7	6	7	6	5	2
15	Missing (if due)	1	2	1	1	3
16	Average score	0.857	0.833	0.834	0.85	0.88	0.925
17	Who is missing it	Omar	Leo, Jonah	Jonah	Omar	Leo, Jonah, Eli
18
19	Leave a cell empty for missing work. Type EX for an excused assignment: it is not counted as missing and its points are left out of Points possible.

How the formulas work

Count missing work that is actually due

H4=SUMPRODUCT(($B$2:$G$2<=$B$13)*(B4:G4=""))

Two tests run across the row: is the assignment due by the date in B13, and is the score empty? Multiplying them turns TRUE/FALSE into 1/0, so only cells that pass both count. Work that is not due yet never shows as missing. Jonah has 3: HW 5, Quiz 3 and HW 6.

List who has not turned in each assignment

B17=IF(B$2>$B$13,"",IFERROR(TEXTJOIN(", ",TRUE,FILTER($A$4:$A$11,B4:B11="")),"Nobody"))

Under each assignment, FILTER picks the student names whose score cell is empty and TEXTJOIN joins them with commas, ready to read out or paste into a reminder. When nobody is missing it, FILTER returns an error, which IFERROR turns into Nobody. Assignments not due yet stay blank. Needs Excel 2021, Microsoft 365 or Google Sheets; the counts in column H work in every version.

Points earned so far, ignoring work not yet due

I4=SUMIFS(B4:G4,$B$2:$G$2,"<="&$B$13)

SUMIFS works sideways too: it adds the scores in the row whose due date is on or before B13. Work handed in early for Lab 2 is left out until Lab 2 is due, so the percentage cannot go over 100%. EX is text, and SUMIFS skips text.

Points possible, without excused work

J4=SUMPRODUCT(($B$2:$G$2<=$B$13)*(B4:G4<>"EX")*$B$3:$G$3)

Adds the point values (row 3) of every assignment that is due and not marked EX. Sofia was excused from the essay, so her possible points are 65 instead of 115. Missing work stays in the total, so it counts as zero in % earned.

Make it yours

Change the date in B13 each week (or replace it with =TODAY() in Excel so it is always current) and every count updates.
Add an assignment by inserting a column before Lab 2, then type its name, due date and points. Inserting inside B to G widens the ranges in columns H to J automatically; if you add a column after Lab 2, extend those ranges by hand.
To send a reminder, copy a cell from the Who is missing it row and paste it with Paste Special > Values, so you get plain names rather than the formula.
Use the Missing (if due) row to see which assignments half the class skipped: that is often a sign the instructions or the deadline were unclear.

FAQ

How do I track missing assignments in Excel?

Leave missing scores empty, then count empty cells for work that is already due: =SUMPRODUCT((due_dates<=as_of)*(scores="")). This template does that for every student and lists, under each assignment, who has not turned it in.

Should a missing assignment count as zero?

That is your grading policy, not an Excel rule. This template counts missing work as zero in % earned and leaves excused (EX) work out completely. If your school uses a minimum score, type it in instead of leaving the cell empty.

Why does the Who is missing it row show #NAME?

Your Excel version does not have FILTER (Excel 2019 and older). The Missing count in column H, Points earned and % earned work in every version; delete row 17 or upgrade to use the name lists.

Functions used

Related guides

More free templates

Updated November 2, 2026