SUMPRODUCT query
Thanks Guys for all your help.
Jim, this worked fine and is all that I was looking for
COUNTA(B5:D100)-COUNT(B5:D100)
Thanks again, Rob
"Gord" wrote in message
...
Thanks Jim
That's the one I was trying to think of<g
Brain dead Sunday............watching too much good ol' boys on TV
Gord
On Sun, 17 Jul 2011 16:18:37 -0700, "Jim Cone"
wrote:
To just get the count of cells that have text, you can use...
=COUNTA(B5:D100)-COUNT(B5:D100)
It subtracts the number count from the count of all cells with an entry
(errors, true/false, text,
numbers, etc).
|