View Single Post
  #11   Report Post  
Old July 19th 11, 10:02 PM posted to microsoft.public.excel.worksheet.functions
Rob[_7_] Rob[_7_] is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2011
Posts: 4
Default SUMPRODUCT query

Thanks Guys for all your help.

Jim, this worked fine and is all that I was looking for

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


On Sun, 17 Jul 2011 16:18:37 -0700, "Jim Cone"

To just get the count of cells that have text, you can use...


It subtracts the number count from the count of all cells with an entry
(errors, true/false, text,
numbers, etc).