View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default Multiple criteria in 2 different columns for a sum in a 3rdcolumn

And if Cyn wants to list the sum of N2:N100 for all occuring different
values in D2:D100 and L2:L100:

Select a sufficiently long area (i.e. 20 rows) and 3 columns and array-
enter:
=Sfreq(D2:D100,L2:L100,N2:N100)

Sfreq you will find he
http://www.sulprobil.com/html/sfreq.html

Regards,
Bernd