=SUM(--(FREQUENCY(IF(A2:A100=11,MATCH(B2:B100,B2:B100,0)) ,ROW(INDIRECT("1:"&ROWS(B2:B100))))0))

this is an array formula, so commit with Ctrl-Shift-Enter, not just Enter

--
__________________________________
HTH

Bob

"Brandon G." wrote in message
...
I have multiple Criteria to count occurrences on. For example,

Division Store_Number
011 01100002
011 01100006
011 01100012
011 01100016
011 01100016
011 01100016
014 01400277
014 01400304
014 01400305
014 01400305
014 01400305


How do I say that there were 4 unique views at division 011 and 3
unique views at division 014?


Thanks in advance


Brandon Galindo