COUNT # times text value occurrs in range

L

loscherland

I want to count the number of times the values 'TRUE' & 'FALSE' occurr
in a list

I've used the following formula but it's returned the wrong value:

=COUNTA(TRUE,or,FALSE,G7:G37)

That returned the value: 34 but there are only 31 records in the lis
which are TRUE or FALSE
 
J

JulieD

Hi Loscherland

use the Countif function

=COUNTIF(E3:E21,"True")+COUNTIF(E3:E21,"False")

Cheers
JulieD
 
R

Ron Rosenfeld

I want to count the number of times the values 'TRUE' & 'FALSE' occurrs
in a list

I've used the following formula but it's returned the wrong value:

=COUNTA(TRUE,or,FALSE,G7:G37)

That returned the value: 34 but there are only 31 records in the list
which are TRUE or FALSE?
Click to expand...

You are not understanding COUNTA. It is counting once for
TRUE
or
FALSE
and once for every entry in the range G7:G37

If you just want to count the TRUE's and FALSE's in that range, then something
like:

=COUNTIF(G7:G37,TRUE)+COUNTIF(G7:G37,FALSE)


--ron
 
Top