Shot down with blanks
You're welcome!
the ""&0 condition gave a count of 0 (zero). Don't know why.
It was using the condition of 0 (greater than 0). So, it would only count
numbers greater than 0.
--
Biff
Microsoft Excel MVP
"Dave" wrote in message
...
Hi,
Thanks heaps. The "?*" condition worked perfectly.
Pooh to needing truly blank cells!
By the way, the ""&0 condition gave a count of 0 (zero). Don't know why.
Thanks again.
Dave.
|