When you compare the two formulas carefully, yours is missing 2 VLOOKUP
statements. Also, the last snippet is not the same. There is a "(" that s/b
")" and on the other side of H5 reference. Also, missing "/" sign.

(VLOOKUP(H5,$D$26:$F$34,2,TRUE)-(H5,$D$26:$F$34,3,TRUE))

(VLOOKUP(H5,D26:F34,2,TRUE)-H5)/VLOOKUP(H5,D26:F34,3,TRUE))



"pytelium" wrote:


Hi JMB

I have entered the following formula into the sheet,but it tells me
there is an error in the formula,I dont know where.

My table is in d25:f34 instead of a1:c11 as in your last post. There is
data in f6 and h6,f7 and h7 etc.,so I will be using autofill. The table
will be unchanged,hence the absolute cell references.

Thanks

=(SUMPRODUCT(--($E$26:$E$34F5),--($d$26:$d$34
<=H5),(($e$26:$e$34-$d$26:$d$34)/$F$26:$F$34)))-((F5-
(F5,$D$26:$F$34,1,TRUE))/VLOOKUP(F5,$D$26:$F$34,3,TRUE)+(VLOOKUP(H5,$D$26:$ F$34,2,TRUE)-(H5,$D$26:$F$34,3,TRUE))


--
pytelium
------------------------------------------------------------------------
pytelium's Profile: http://www.excelforum.com/member.php...o&userid=25521
View this thread: http://www.excelforum.com/showthread...hreadid=476928