| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count if with multiple criteria | Excel Worksheet Functions | |||
| Count multiple cells against multiple criteria in an Excel spreads | Excel Worksheet Functions | |||
| Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
| Count multiple criteria | Excel Worksheet Functions | |||
| multiple criteria for count if | Excel Discussion (Misc queries) | |||
Linear Mode
