| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to count based on multiple criteria fields w/duplicates
Hello,
I suggest to array-enter into a select range of 5 rows and 2 columns: =Pfreq(Pfreq(B24:B39&"-"&C24:C39,A24:A39,D24:D39)) [assuming your data resides in A24:D39] Pfreq you can find he http://www.sulprobil.com/html/pfreq.html Regards, Bernd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count based on multiple criteria | Excel Worksheet Functions | |||
| How do I get the count in excel based on criteria in multiple col | Excel Worksheet Functions | |||
| count based on multiple date criteria | Excel Worksheet Functions | |||
| how do i count values based on multiple criteria | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Threaded Mode
