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

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

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" wrote in message
oups.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

sorry, that was my test range, should be

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


--

HTH

RP

"Bob Phillips" wrote in message
...
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" wrote in message
oups.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

Thanks Bob that worked like a charm