=COUNTIF(E1:E6,".")
"Biff" wrote in message
...
Why not just countif on NO ?
Biff
"Max" wrote in message
...
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.
|