Thread: Formula to count based on multiple criteria fields w/duplicates
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default 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
Reply With QuoteReply With Quote