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

[Guest]

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.

 

[Max]

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

 

[Guest]

I will try this, Thanks

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

 

[Biff]

Why not just countif on NO ?

Biff

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

 

[Jim May]

=COUNTIF(E1:E6,".")

Why not just countif on NO ?

Biff

 

[Max]

Why not just countif on NO ?

... Then count the number of dots for a total ...

except of course, s/he wanted dots and I suggested "OK"

 

[Max]

You're welcome !
Thanks for the post back