The above wasn't working. When column H items were changed to DAYOFF for example the results wouldn't budge. (I thought I'd checked everything out.)

It works with this one.

=SUM(IFERROR(((C2:H2={"MIAOUT";"MIA";"UPTO"})+(-1*(C2:H2={"";"<>MIAOUT";"<>MIA";"<>UPTO"}))),FALSE))


It was the offsetting ranges causing the goof. The DAYOFF and HOLOFF were unnecessary, too.