Hi all,
I was wondering if you could help me identify on what formula to use in order for me to count absences for each month and at the same time will accumulate that number.
So say, the sheet will count all the absences that the person made and if he/she accumulated more than 3, then the person's name will turn red.
please see screenshot below:
https://1drv.ms/u/s!AnoqCs4SvIlxgmhmMLxQY-7Vr-0V
PS.
The highlighted cells in the image are the ones where I want to get the data for my formula.
Thank you helpful souls!
I was wondering if you could help me identify on what formula to use in order for me to count absences for each month and at the same time will accumulate that number.
So say, the sheet will count all the absences that the person made and if he/she accumulated more than 3, then the person's name will turn red.
please see screenshot below:
https://1drv.ms/u/s!AnoqCs4SvIlxgmhmMLxQY-7Vr-0V
PS.
The highlighted cells in the image are the ones where I want to get the data for my formula.
Thank you helpful souls!