View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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.