Ooops!

You could use any of the counting techniques: Sumif,

Obviously, Sumif is not a counting technique!

Biff

"Biff" wrote in message
...
No. You could use any of the counting techniques: Sumif, Sumproduct,
Sum(IF, Count(If.

But COUNTIF is the best choice. Also, Countif is the only function that
gets "confused" on the TEXT versus LOGICAL true.

I would change the logical Countif to:

COUNTIF(A1:A10,TRUE)

Just so that I wouldn't get confused and think "true" refers to text.

Biff

"Epinn" wrote in message
...
Biff or anyone,

Is this the only way to count both text "true" and logical TRUE?

=COUNTIF(A1:A10,"*true")+COUNTIF(A1:A10,"true")

Thanks.

Epinn