Try something along these lines ..

Assuming answers ("No") will be in col A , A1 down

Put in B1: =IF(TRIM(A1)="","",IF(TRIM(A1)="No","OK",""))
Copy B1 down to say, B100 to cover the max expected range in col A
(can copy down ahead of data input in col A)

Then you could put in say, C1: =COUNTIF(B:B,"OK")
to count the total

Replace "OK" in the formulas with whatever indicator you want to show as the
correct response ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"alaskatpj" wrote in message
...
I am trying to fiqure out how I can set up a worksheet that when I want no
to
be the answer it will put a dot in the cell. Then count the number of dots
for a total.