Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
=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. |
#6
|
|||
|
|||
"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 ---- |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create excel spreadsheet to display data from filled text forms | Excel Discussion (Misc queries) | |||
How do I create a spreadsheet to track monthly inventory | New Users to Excel | |||
how to create and use a new spreadsheet based on a template | Excel Discussion (Misc queries) | |||
Convert simple spreadsheet to XML | Excel Discussion (Misc queries) | |||
How Do I create a spreadsheet with a finite set of columns and ro. | New Users to Excel |