Quote Originally Posted by duane
this should fix it - ) before ,"No Apps" and I missed one on the countif

=IF(AND(ISNA(MATCH("NS",E1:I1,0)),SUM(E1:I1)=0),"No Apps",SUM(E1:I1)/(C1*(COUNTIF(E1:I1,">=0")+COUNTIF(E1:I1,"NS"))))

It WORKS!!!!!!!!!!!!!!!!!!!!!!!!!!

Yeah!!! To me that was the hard one, the one I HAD to get.

Thank you thank you thank you!