hi all,

I need a UDF to help me determine how many occasions of sickness an employee has had. for each week he is sick it's marked as a 1 in my table. the data runs from d2:bb2.

so if my columns looks like

111100000111001000111

the answer would be 4 because he was off sick for 4 weeks the first time then came back and went off sick for another 3 weeks and then back for 2 weeks etc etc

all help appreciated guys. I need to put the answer in cell bc2

thanks again