software

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(WE EKDAY($F$3:$CT$3,2),{0,1.13;5,1.23}))

Thanks in advance.

EP--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: www.excelforum.com/member.php...oamp;userid=33809
View this thread: www.excelforum.com/showthread...hreadid=541884Try...

=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!

In article
gt;,
edwardpestian
gt; wrote:

gt; Is there anyway to change the 1.13 and 1.23 at the end of this formula
gt; to a cell reference: for example DK6 and DK7?
gt;
gt; =SUMPRODUCT(--(MOD(COLUMN($F74:$CT74),3)=0),$F74:$CT74,LOOKUP(WE EKDAY($F$3:$CT
gt; $3,2),{0,1.13;5,1.23}))
gt;
gt; Thanks in advance.
gt;
gt; EP


Worked Great!

Thanks for the help.

EP--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: www.excelforum.com/member.php...oamp;userid=33809
View this thread: www.excelforum.com/showthread...hreadid=541884