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: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=541884

Try...

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

Hope this helps!

In article
,
edwardpestian
wrote:

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

Worked Great!

Thanks for the help.

EP


--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile: http://www.excelforum.com/member.php...o&userid=33809
View this thread: http://www.excelforum.com/showthread...hreadid=541884