Cell Reference in formula
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 |
Cell Reference in formula
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 |
Cell Reference in formula
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 |
All times are GMT +1. The time now is 09:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com