Thread: Counting data that meets 3 different Criteria
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Counting data that meets 3 different Criteria
Hello,

IMHO Sumproduct is a suboptimal approach here. See here why:
http://sulprobil.com/html/sumproduct.html

If you do not like to use pivot tables I suggest to use one of my
UDF's Pfreq, Mfreq or Pstat:
http://sulprobil.com/html/listfreq.html

Regards,
Bernd
Reply With QuoteReply With Quote