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 <at>yahoo<dot>com
----
"alaskatpj" <alaskatpj@discussions.microsoft.com> wrote in message
news:5A32BA04-D4FA-4075-805D-89502BD18268@microsoft.com...
> 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 <at>yahoo<dot>com
> ----
> "alaskatpj" <alaskatpj@discussions.microsoft.com> wrote in message
> news:5A32BA04-D4FA-4075-805D-89502BD18268@microsoft.com...
> > 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.
>
>
>

You're welcome !
Thanks for the post back
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"alaskatpj" <alaskatpj@discussions.microsoft.com> wrote in message
news:D875D495-E47C-4330-9621-6E0B721B69C1@microsoft.com...
> I will try this, Thanks

Why not just countif on NO ?

Biff

"Max" <demechanik@yahoo.com> wrote in message
news:%23$9HMV7RFHA.3444@tk2msftngp13.phx.gbl...
> 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 <at>yahoo<dot>com
> ----
> "alaskatpj" <alaskatpj@discussions.microsoft.com> wrote in message
> news:5A32BA04-D4FA-4075-805D-89502BD18268@microsoft.com...
>> 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" <biffinpitt@comcast.net> wrote in message
news:eATwTb8RFHA.3972@TK2MSFTNGP14.phx.gbl...
> Why not just countif on NO ?
>
> Biff
>
> "Max" <demechanik@yahoo.com> wrote in message
> news:%23$9HMV7RFHA.3444@tk2msftngp13.phx.gbl...
> > 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 <at>yahoo<dot>com
> > ----
> > "alaskatpj" <alaskatpj@discussions.microsoft.com> wrote in message
> > news:5A32BA04-D4FA-4075-805D-89502BD18268@microsoft.com...
> >> 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" <biffinpitt@comcast.net> 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 <at>yahoo<dot>com
----