We can use a "if blank then blank" approach

=IF(COUNTA(C8:AF8)=0,"",100-(COUNTIF(C8:AF8,"No")*10))

Simply put, if there is no data, display blank.
If there is data, use the formula.
--
Gary's Student
gsnu200701


"Meenie" wrote:

The problem is if I want to print out the blank form. The formula I'm using
is =100-(COUNTIF(C8:AF8,"No")*10)
But if I erase all the info from the form so I can print it out blank, the
totals
stay 100 and I want those cells to be blank until info is entered. How can I
do that?
Yikes...