| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying formula with cell reference decreasing automatically | Excel Discussion (Misc queries) | |||
| how to paste formula but reference a fixed cell | Excel Discussion (Misc queries) | |||
| Function/ formula to output a cell reference | Excel Worksheet Functions | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
| copied formula has correct cell reference, but result of original | Excel Worksheet Functions | |||
Threaded Mode
