This sounds easy but I'm finding the task incredibly difficult.
I am working on our college's attendance registers and, up to now, have had no problems with the formulae to calculate attendance figures (absent, authorised absence, present, etc.). I have now been asked to include a column to indicate the number of times a student has been late. This means that the cell will have the date of the class, but include a comment that simply says 'LATE'. I need a column that just counts the number of time a 'LATE' comment has been included.
This would be easy if only the late cells had a comment, but the authorised absence cells also include a comment with the reason they have been given the absence. I've worked out how to 'CountComments' (thanks to this forum) but I only need the cumulative figure for LATE.
I'm pulling my hair out! Can anyone help?