Counting Text

L

locutus243

I have a list of text (e.g:-

True
False
True
True
False

I want the cell which will count how many times False appears in thi
column of cells. I assume its a fairly easy function but I dont kno
which one!!

Cheers

Mar
 
D

Dave Peterson

If it's really text--not boolean TRUE/FALSE, then how about:

=sumproduct(--(a1:a1000="false"))
 
Top