bradford factor

For what it's worth, these array formulas seem to work in xl2003...

SUM(IF((A1:H1="sick")*(B1:I1<>"sick"),1,""))+(H1="sick")*(I1="sick")+(H1<>"sick")*(I1="sick")

if there can't be a blank cell between the formula and the rightmost row 1 cell set aside for entry of "sick" or left blank for "not sick".

SUM(IF((A1:I1="sick")*(B1:J1<>"sick"),1,""))

if you are able to move the formula one cell to the right of the cells set aside for entries.