Count if ('true) does not work

[JMod]

I am trying to tabulate the results of a web survey that have been
stored in a database and ported to excel. Unfortunately the survey
makes extensive use of True/False questions. Since Excel interperates
True and False as boolean values in the cell the DB back quoted all
response as 'true or 'false. But now when I want to count them in a
[Countif(A2:A23, 'true')]formula I get a 0 returned every time.

I've tried different ways of trying to get Excell to understand what I
am looking for, short of manually changing all cell values to TRUE or.
FALSE. (which could cause data integriy problems)

any help would really make my job easier.

-jmod

[Dave Peterson]

I'd try one of these:

=countif(a2:a23,true)
or
=countif(a2:a23,"True")





JMod wrote:
>
> I am trying to tabulate the results of a web survey that have been
> stored in a database and ported to excel. Unfortunately the survey
> makes extensive use of True/False questions. Since Excel interperates
> True and False as boolean values in the cell the DB back quoted all
> response as 'true or 'false. But now when I want to count them in a
> [Countif(A2:A23, 'true')]formula I get a 0 returned every time.
>
> I've tried different ways of trying to get Excell to understand what I
> am looking for, short of manually changing all cell values to TRUE or.
> FALSE. (which could cause data integriy problems)
>
> any help would really make my job easier.
>
> -jmod

--

Dave Peterson

[Bob Phillips]

It is not clear what formula u r using. If u used

=COUNTIF(A2:A23,'true') you would get an error.

If it is because the cells are text, try

=SUMPRODUCT(--(H9:H17="TRUE"))


--

HTH

RP

"JMod" <john.g.martinson@gmail.com> wrote in message
news:1137539661.322668.283620@g47g2000cwa.googlegroups.com...
> I am trying to tabulate the results of a web survey that have been
> stored in a database and ported to excel. Unfortunately the survey
> makes extensive use of True/False questions. Since Excel interperates
> True and False as boolean values in the cell the DB back quoted all
> response as 'true or 'false. But now when I want to count them in a
> [Countif(A2:A23, 'true')]formula I get a 0 returned every time.
>
> I've tried different ways of trying to get Excell to understand what I
> am looking for, short of manually changing all cell values to TRUE or.
> FALSE. (which could cause data integriy problems)
>
> any help would really make my job easier.
>
> -jmod
>

[Bob Phillips]

sorry, that was my test range, should be

=SUMPRODUCT(--(A2:A23="TRUE"))


--

HTH

RP

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:uiZt727GGHA.984@tk2msftngp13.phx.gbl...
> It is not clear what formula u r using. If u used
>
> =COUNTIF(A2:A23,'true') you would get an error.
>
> If it is because the cells are text, try
>
> =SUMPRODUCT(--(H9:H17="TRUE"))
>
>
> --
>
> HTH
>
> RP
>
> "JMod" <john.g.martinson@gmail.com> wrote in message
> news:1137539661.322668.283620@g47g2000cwa.googlegroups.com...
> > I am trying to tabulate the results of a web survey that have been
> > stored in a database and ported to excel. Unfortunately the survey
> > makes extensive use of True/False questions. Since Excel interperates
> > True and False as boolean values in the cell the DB back quoted all
> > response as 'true or 'false. But now when I want to count them in a
> > [Countif(A2:A23, 'true')]formula I get a 0 returned every time.
> >
> > I've tried different ways of trying to get Excell to understand what I
> > am looking for, short of manually changing all cell values to TRUE or.
> > FALSE. (which could cause data integriy problems)
> >
> > any help would really make my job easier.
> >
> > -jmod
> >
>
>

[JMod]

Thanks Bob that worked like a charm

[olasa]

I am surprised that after 7years =COUNTIF(A1,A1) with A1='true still produce the wrong answer, 0.
You would have thought Excel's programmers could fixed it, but it is probably too difficult ;-)