Dynamic Named Ranges using text

		Microsoft Office Forums > Microsoft Excel > Excel
Dynamic Named Ranges using text

FAQ

Thread Tools

Display Modes

06-22-2010, 04:42 PM

hannu

Windows Vista Dynamic Named Ranges using text

Office 2007

Advanced Beginner

Join Date: May 2010

Location: Sydney, Australia

Posts: 30

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:10 AM.