Reply
 
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
COUNTA(B5100)-COUNT(B5100)

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(B5100)-COUNT(B5100)

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





Reply
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