Thread: sumproduct and weekday?
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pub pub is offline
external usenet poster
  
Posts: 29
Default sumproduct and weekday?
Bernd P wrote in news:04c8b36b-6b1c-4299-b895-
:

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

thanks so much,
with the help i got here, i got the formula working.
Reply With QuoteReply With Quote