I'm a teacher and I have a record of student absences like this:

Name Nov. 4 Nov. 5 Nov. 6 Nov. 7
Divine absent present absent late
Riza absent present absent absent
Aira absent absent absent absent

In their summary records, I want two different pieces of data: number of absences (simple countif) and number of occurrences, wherein if it's consecutive, it's counted as one.

For example, Divine would have an A of 2 and an O of 2. Riza would have an A of 3 and an O of 2. Aira would have an A or 4 and an O of 1.

Any macro or formula is much appreciated.
Thanks!