=IF(COUNTIF(C7:U7,0),0,COUNTIF($C$8:$K$8,0)+COUNTI F($M$8:$U$8,0))


"Sandy" wrote:

Any ideas on how to shorten the following:-

Thanks

Sandy



=IF(OR(C7=0,D7=0,E7=0,F7=0,G7=0,H7=0,I7=0,J7=0,

K7=0,M7=0,N7=0,O7=0,P7=0,Q7=0,R7=0,S7=0,

T7=0,U7=0),0,COUNTIF($C$8:$K$8,0)+COUNTIF($M$8:$U$ 8,0))