Thread: Multiple Criteria Sum
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default Multiple Criteria Sum
Hello,

I suggest to select a range of 4 rows and 3 columns and to array-
enter:
=Sfreq(A1:A5,B1:B5,C1:C5)

Sfreq is a UDF which you can find he
http://sulprobil.com/html/sfreq.html

Regards,
Bernd
Reply With QuoteReply With Quote