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
|