Hello I'm just wondering if there is a more way of my formula in column NH4
I've repeated the formula to get the correct results but it's massive.
I don't know how to condense the formula down.
The formula is used to count instances of sick time off of based on the text "s" and "sh" the "rd" bridges the gap so the sickness is a single occurrence as opposed to multiple instances once you factor in rest days.
=SUM(IF(FREQUENCY(IF(B4:NF4="s",COLUMN(B4:NF4)),IF(B4:NF4<>"s",COLUMN(B4:NF4))),1))+SUM(IF(FREQUENCY(IF(B4:NF4="sh",COLUMN(B4:NF4)),IF(B4:NF4<>"sh",COLUMN(B4:NF4))),1))-SUM(IF(FREQUENCY(IF(B4:NF4="rd",COLUMN(B4:NF4)),IF(B4:NF4<>"rd",COLUMN(B4:NF4))),1))
I hope that makes sense?
Any help appreciated.
Bookmarks