Posted to microsoft.public.excel.worksheet.functions

Paul Dennis

Posts: n/a

COUNTIF 2 Conditions using Defined Names

SLA_GROUP is a defined name for a COL A
NO_ROLL_NUM is a defined name for COL B

COUNTIF(SLA_GROUP,$C5) works but I'm trying to COUNTIF based on SLA_GROUP =
C% and also were NO_ROLL_NUM = 11.

any ideas?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Rename Defined Names	Sige	Excel Worksheet Functions	3	January 13th 06 05:44 PM
How to delete all defined names from a workbook?	Dmitry Kopnichev	Excel Worksheet Functions	15	November 14th 05 03:26 PM
COUNTIF - multiple conditions	allphin	Excel Worksheet Functions	4	September 18th 05 04:05 PM
How can I use COUNTIF to sum for two conditions?	Jeff	Excel Worksheet Functions	4	December 30th 04 05:25 AM
Combining Defined Names to New Name For Validation	TheSpankster22	Excel Worksheet Functions	0	November 4th 04 01:28 AM

All times are GMT +1. The time now is 03:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us