Count if ('true) does not work

  • Thread starter Thread starter JMod
  • Start date Start date
J

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
 
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
Click to expand...
 
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"))
 
sorry, that was my test range, should be

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


--

HTH

RP

Bob Phillips said:
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 said:
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
Click to expand...
Click to expand...
 
Back
Top