ExcelBanter - Count Multiple Criteria

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count Multiple Criteria (https://www.excelbanter.com/excel-worksheet-functions/198540-count-multiple-criteria.html)

Count Multiple Criteria

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

Count Multiple Criteria

=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