Count Multiple Criteria

  • Thread starter Thread starter Brandon G.
  • Start date Start date
B

Brandon G.

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
 
=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
 
Back
Top