i want to create a simple yes/no spreadsheet with a dot represent.
 

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.

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.

I will try this, Thanks

"Max" wrote:

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.

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.

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

"Biff" wrote
Why not just countif on NO ?
Was guilty in following the OP's specs to the letter <g,
... Then count the number of dots for a total ...
except of course, s/he wanted dots and I suggested "OK"
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

You're welcome !
Thanks for the post back
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"alaskatpj" wrote in message
...
I will try this, Thanks