This is the problem I working on: http://www.excelforum.com/excel-form...the-money.html
This is the method I will use: http://www.excelforum.com/excel-form...-in-range.html
Below is the formula in my excel sheet:
K11 =ROUND(I11*('Summary Sheet'!H32/H11),2)
L11 =ROUND(MIN(K11,$C11-SUMPRODUCT($H11:J11,MMULT(ROW(11:11)^0,IF(MOD(COLUMN($H11:J11)-COLUMN($H11)+1,4)=0,1,0)))),2)
M11 =ROUND(L11+IF(K11>L11,0,L11*(SUM(Start:End!K11-Start:End!L11)/SUMIF(Start:End!L11,Start:End!K11>Start:End!L11))),2)
In cell I11, H11, H32, $C11 contains very simple calculation that will return Value or else "". The SUMPRODUCT in L11 is to calculate the Sum of every 4 column over and should return Value.
What I want to do is to combine formula in K11 and L11 into M11 because it need to fit my excel form for cell reference. My only problem is when working on M11, where I want to replace the Start:End!K11 and Start:End!, which shows error that I have the formula wrong and I cannot identify the error. Anyone have any idea?
*Sample Workbook attach in post #3*
Bookmarks