View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RD Wirr RD Wirr is offline
external usenet poster
 
Posts: 55
Default Multiple Criteria Sum

Hi Bernd,

I tried your UDF and it works well. Thanks for that. But is there a way to
make the UDF follow along with the file I am working on? This spreadsheet is
for other people to use and it will be too complicated to get them to run
this bit of code each time they open the spreadsheet. I guess you can tell I
am no programmer...

Thanks,
RD

"Bernd P" wrote:

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