Hi John,
I'm sorry, I missed this when you wrote it ... but I don't think it would've
quite done the job because one of the answers is also N/A and I wouldn't want
it to count that.
Thanks :)

"John Bundy" wrote:

This worked for me, let me know.
=100-(COUNTIF(C8:AF8,"N*")*10)

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

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