Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 06-22-2010, 04:42 PM
hannu hannu is offline Windows Vista Office 2007
Advanced Beginner
 
Join Date: May 2010
Location: Sydney, Australia
Posts: 30
hannu is on a distinguished road
Default Dynamic Named Ranges using text

I have created a Dynamic Named Ranges which works as should SUMming numbers but I want to use a COUNTIF function to count names. The Table is named Clients and I want to count how many "Marys" are in my list. the list expands about 100 rows per week so a range of cells is not a practical solution. The current formula is: =COUNTIF(Clients,"Mary")



Thanks for help in advance
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic alignment? Corporem Word 1 05-20-2010 10:55 AM
Can't import home adresses in outlook 2010 from excel named ranges eekie Outlook 0 05-14-2010 02:04 PM
Dynamic Charts... herbycanopy Excel 3 04-09-2010 05:58 PM
Outlook Web Access: How to load the "Microsoft Dynamic Html Editing Control" Add-On? tomtom67 Outlook 1 08-31-2009 12:23 AM
Identifying the Dynamic Connector cyberbhai Misc 0 12-14-2005 03:55 AM


All times are GMT -7. The time now is 07:04 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft