formula for B5 - then copy formula down the column

= if(countif(C5:E5, "absent")=3,"Needs Follow up","")

"Boogie" wrote:

This is about Sundays attendance for our members. This is what I want to
accomplish. If a member is absent for 3 sundays consecutively (e.g on
C5=absent, D5=absent and E5=absent, then it will tell me on B5 as "Needs
Follow up". The same thing goes on other columns up to 300. Thanks