Cell Reference in formula

[edwardpestian]

Is there anyway to change the 1.13 and 1.23 at the end of this formula
to a cell reference: for example DK6 and DK7?

=SUMPRODUCT(--(MOD(COLUMN($F74:$CT74),3)=0),$F74:$CT74,LOOKUP(WEEKDAY($F$3:$CT$3,2),{0,1.13;5,1.23}))

Thanks in advance.

EP

 

[Domenic]

Try...

=SUMPRODUCT(--(MOD(COLUMN($F74:$CT74)-COLUMN($F74),3)=0),$F74:$CT74,LOOKU
P(WEEKDAY($F$3:$CT$3,2),{0;5},DK6K7))

Hope this helps!

edwardpestian

 

[edwardpestian]

Worked Great!

Thanks for the help.

E