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