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