Well, just when you think it's safe to go in the water.....
I used this formula: =100-(COUNTIF(C8:AF8,"No")*10)
and thought it worked great but then discovered some people
used "N" for no and some typed out "No" for no. How do I make it work for
both?
I tried using "if" in there a couple of different ways, but I'm doing
something wrong. Excel keeps yelling
at me :)

"Bernard Liengme" wrote:

It would help if you stayed with one thread
Try something like =IF(COUNTA(C8:AF8)0,100-(COUNTIF(C8:AF8,"No")*10) , "")
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Meenie" wrote in message
...
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...