Difficult formula SUMPRODUCT,MATCH,WEEKDAY

All of the cell references were to another worksheet. Once I included the reference to the other sheet Data!, it worked like a charm.

Many Thanks.

EP

You could simplify it somewhat

=SUMPRODUCT(--(MOD(COLUMN(F9:CT9),3)=0),F9:CT9,LOOKUP(WEEKDAY(F3:CT3,2),{0,1.13;5,1.23}))

Can I add a cell reference for the 1.13 and 1.23: Data!DC6, and Data!DC7 respectively.

I tried and its not working.

Thanks again.

EP

You can do that this way

=SUMPRODUCT(--(MOD(COLUMN(F9:CT9),3)=0),F9:CT9,LOOKUP(WEEKDAY(F3:CT3,2),{0;5},data!DC6:DC7))