Difficult formula SUMPRODUCT,MATCH,WEEKDAY

Not really sure where to start with this one. I have a forumula, =SUMPRODUCT(--(MOD(COLUMN(F9:CT9),3)=0),F9:CT9). I need to incorporate a MATCH function so that it matches the date in row f3. Similar to =IF(Date=0,"",OFFSET($E$5:$E$103,,MATCH(Date,$F$3:$CX$3,0))).

Ultimately, I need the formula to sum every third column, based on the date in the range F3:CX3, and then multiply each column whose date is a weekday (Mon-Thu) by 1.13 and weekend (Fri-Sun) by 1.23

Thanks in advance.

EP

It looks like it would work, but its giving me an answer of zero.

Thanks for the help.

EP

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))