COUNT # times text value occurrs in range

[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

 

[JulieD]

Hi Loscherland

use the Countif function

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

Cheers
JulieD

 

[loscherland]

Nice one, thanks.

 

[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?

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

 

[JulieD]

Hi

glad to assist.

Cheers
JulieD