View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob[_7_] Rob[_7_] is offline
external usenet poster
 
Posts: 4
Default 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).