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

A

alaskatpj

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

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

alaskatpj

I will try this, Thanks

Max said:
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 ..
Click to expand...
 
B

Biff

Why not just countif on NO ?

Biff

Max said:
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 ..
Click to expand...
 
Top