Count Unique Occurrences

[Brandon G.]

I have multiple Criteria to count occurrences on. For example,

Division Store_Name
011 01100002 Irmo
011 01100006 MYRTLE BEACH
011 01100012 FOREST ACRES
011 01100016 Myrtle Beach
011 01100016 Myrtle Beach
011 01100016 Myrtle Beach
014 01400277 Ft. Mitchell
014 01400304 Cincinnati
014 01400305 Cincinnati
014 01400305 Cincinnati
014 01400305 Cincinnati

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

 

[Teethless mama]

=SUM(N(FREQUENCY(IF(Division=11,MATCH(Store_Name,Store_Name,)),MATCH(Store_Name,Store_Name,))>0))

ctrl+shift+enter, not just enter

 

[Teethless mama]

Another...

=SUMPRODUCT((Division=11)/COUNTIF(Store_Name,Store_Name))

 

[Brandon G.]

=SUM(N(FREQUENCY(IF(Division=11,MATCH(Store_Name,Store_Name,)),MATCH(Store_­Name,Store_Name,))>0))

ctrl+shift+enter, not just enter









- Show quoted text -

What does Sum(N mean?