The course I teach consists of 5 units. I need to record the date each
student completes each of the 5 units and produce a report each month
detailing how many students have completed each unit within that month.

i.e. Unit 1 10 Unit 2 15

The dates are contained in cells F20:J122 and I need a total for each column.

I hope this makes it clearer!

Thanks


"Bob Phillips" wrote:

Louise,

There is, but to properly help you, describe the data and the cells it is
in.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"louise" wrote in message
...
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