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).