Hi,

If desired, kindly send the file to me at ask(at)ashishmathur(dot)com.
Please explaint he problem very clearly. Thank you.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Jo" wrote in message
...
Hello,

I am trying to count the number of times an item occurs with multiple
requirements. I have the overall count of all by name and with other
multiple countif requirements, but now I need to find the count of the
number
of unique items by ID and unique IDs with other criteria as well. Some
of
the column ID's may not have numbers in them, but I would still like them
counted. For instance, see below.

Overall
Total number of companies for North - 4
Total number of unique companies for North - 2
With additional criteria
Total number of companies in West and Small Market - 3
Total number of unique companies in West and Small Market - 1(does not
have
a unique ID to identify them and name may be slightly different))

Name Region Market Manager ID
ABC- North Large Bob 123
DEF East Med Joe 345
GHI South Med Jane 234
JKL West Small Joe
MNO West Med Jane 686
PQR North Small Jane 897
STU West Med Joe 976
VWX East Large Bob
YZ South Med Jane 967
ABC Inc North Large Bob 123
ABC North Large Bob 123
JKL West Small Joe
JKL Inc West Small Joe

Any help would be appreciated! Thanks!