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")

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]

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"))

 

[Bob Phillips]

sorry, that was my test range, should be

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


--

HTH

RP

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

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