LinkBack Thread Tools Search this Thread Display Modes
  #11   Report Post  
Old July 19th 11, 10:02 PM posted to microsoft.public.excel.worksheet.functions
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).

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sumproduct query Marc T Excel Worksheet Functions 4 June 1st 09 04:46 PM
SUMPRODUCT query John Excel Discussion (Misc queries) 3 March 18th 08 10:57 PM
Another SUMPRODUCT Query enna49 Excel Worksheet Functions 4 June 29th 07 06:20 AM
Sumproduct query shakey1181 Excel Discussion (Misc queries) 7 May 18th 07 02:49 PM
I think its a sumproduct query? Scoosh Excel Discussion (Misc queries) 0 September 8th 05 12:45 AM

All times are GMT +1. The time now is 10:18 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017