Dynamic Named Ranges using text

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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 03:46 AM.