One check if there are some entries, the other checks if there are no
entries.
Is the glass half-full or half-empty?
There is nothing to choose between the two formulas
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Meenie" wrote in message
...
Both of these formulaes work well, is there a reason one would be better
than
the other?

"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...