Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-22-2010, 04:42 PM
hannu hannu is offline Dynamic Named Ranges using text Windows Vista Dynamic Named Ranges using text Office 2007
Advanced Beginner
Dynamic Named Ranges using text
 
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

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Named Ranges using text 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 Named Ranges using text Dynamic Charts... herbycanopy Excel 3 04-09-2010 05:58 PM
Dynamic Named Ranges using text 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft