I am a teacher and use a spreadsheet to keep a record of when students have
completed an assignment.

I need to produce a monthly report detailing how many students completed
each unit within the last month.

Is there a function that can do this?

Thanks