View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
 
Posts: 806
Default sumproduct and weekday?

Hello,

Array-enter (with CTRL + SHIFT + ENTER, not just ENTER!)
=SUMPRODUCT(((D1:AH1)-120)*((D1:AH1)-12)*TRANSPOSE(WEEKDAY(A1+ROW
(A1:A31))<6))
and you will get your (correct?) result 13.

The ROW() creates a vertical array which needs to get transposed...

Regards,
Bernd