Hi,

I need help with an absence tracker! I would like to have a formula that show amount of periods the employee has been absence.

like i have the name of the employee (Mike) in colum A2 and after that to S2 all days in the month.

so say that Mike is sick for 3 days that i mark (S) in cell B2 - C2 - D2 thats is 3 days but one period.

But mike is also sick 2 more days that month that i mark (S) in cell H2 - I2 thats 2 days and 1 period.

so what i need help with is the period part, what kind of formula will help me with this?

Thanks in advance // Fredrik