Prev: Stop text carries over
Next: Removing unwanted columns in a list
From: The snow Queen The snow on 4 Jul 2008 04:36
Hello all i have seen that a person has asked if this can be done as a block
of three but i would like to do this on a larger scale will the formula
still fit. to count the yes's as 1.
From: Pete_UK on 4 Jul 2008 05:02
Don't know what formula you are referring to, but try this:

=COUNTIF(range,"Yes")

Hope this helps.

Pete

On Jul 4, 9:36 am, The snow Queen <The snow
Qu...(a)discussions.microsoft.com> wrote:
> Hello all i have seen that a person has asked if this can be done as a block
> of three but i would like to do this on  a larger scale will the formula
> still fit. to count the yes's as 1.

From: NoodNutt on 4 Jul 2008 20:12
G'day Pete

I could be wrong , but I think the OL' Snow Queen is possibly referring more
to a true/false.

=IF(A1="Yes",1,0)

Regards
Mark.


From: Dave Peterson on 4 Jul 2008 20:49
If that's true, then here's another formula:

=--(A1="yes")

A1="Yes"
returns true or false
-true or -false returns -1 or -0 (0)
and
--1 or --0 returns 1 or 0




NoodNutt wrote:
>
> G'day Pete
>
> I could be wrong , but I think the OL' Snow Queen is possibly referring more
> to a true/false.
>
> =IF(A1="Yes",1,0)
>
> Regards
> Mark.

--

Dave Peterson
 | 
Pages: 1
Prev: Stop text carries over
Next: Removing unwanted columns in a list