Thread
:
countif results
View Single Post
#
4
kk
Posts: n/a
Try this
=SUMPRODUCT(--(A10:A20="TRUE"))
Does it help?
"Lookin for a job" <Lookin for a
wrote in
message ...
Hello Guys..
I have a range of IF formulas in A10:A20 that return either a text "True"
(not a boolean) or a blank "" .
There are several "Trues" in the range but when I use -
=Countif(A10:A20,"True")
I get a result of 0.
Why is this?
Thanks
Reply With Quote