Calculating the number of cells containing dates within the la
Louise,
Assuming that the namesare in column A, put the list of months in A123 down
as Jan, Feb, etc.,, then then add this to F123
=SUMPRODUCT(--(TEXT(F$20:F$122,"mmm")=$A123))
and then copy down and across to J
--
HTH
RP
(remove nothere from the email address if mailing direct)
"louise" wrote in message
...
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
|