Hi

=COUNTIF(A1:A100,TRUE)

Regards,
Per

"hmm" skrev i meddelelsen
...
How do I use boolean values so that a formula would evaluate TRUE as 1 and
FALSE as 0? For example, if column A contains boolean values, I want to
avoid formulas like {SUM(IF(A1:A100, 1, 0))}. Instead, I would like to
just
enter {SUM(A1:A100)}. Presently, in such a formula both TRUE and FALSE
are
treated as 0.