Try...

=SUM(IF(FREQUENCY(IF(CategoryRange="Category",IF(I temRange<"",MATCH("~"&
ItemRange,ItemRange&"",0))),ROW(ItemRange)-MIN(ROW(ItemRange))+1),1))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
Btaylor64 wrote:

Good morning!
About a week ago, I received an amazing formula on this website, for
counting the number of unique items within different categories.
Specifcally, my problem was:

ITEM CATEGORY
apple A
apple A
bannana A
bannana B
bannana B

So I wanted Excel to figure out that there are 2 unique items in
Category A ("apple" and "bannana"), and only one in Category B ("bannana").
The solution I was given was:


=SUM(IF(FREQUENCY(IF(CategoryRange="Category",MATC H"~"&ItemRange,ItemRange&"",
0)),ROW(ItemRange)-MIN(ROW(ItemRange))+1),1))

This is a fantastic solution and it works perfrectly - except that it
also counts blank cells as a unique entry, too!
Is there a way to keep Excel from counting blank cells as a unique item
in each category?

Thanks again for the help you guys are providing on this amazing
website!!
-Brett