Posted to microsoft.public.excel.worksheet.functions
|
|
TRUE - Boolean vs. Text
See this:
http://tinyurl.com/u3gh6
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
|