Perhaps =IF(and($F22+$G22+$H22+$K22+$J22+$L22+$N22+$O22+$P22>=1,$C22=""),"ERROR",SUM($Q22,$M22,$I22)) OTH:" if cells f22 through p22 are greater than or equal to 1 and if c22 is blank then show error otherwise do the sum of q m and i 22" is not quite clear. Their sum could be larger than 1 although each individual cell light be smaller than 1
Bookmarks