Need Calculation to start before the formula

Apologies, idea posted originally didn't work.

Ochimus

If I understand correctly, it seems like it should be as simple as replacing the one A11 reference with A4
current formula in B11 =if(and(A11>=$D$1,A11<=$G$1),$I$1*A11,"")
replace with =if(and(A11>=$D$1,A11<=$G$1),$I$1*A4,"") in B11 and copy/paste/fill down.

Named ranges
C.1 =Sheet1!$I$1
Length =Sheet1!$A$4:$A$101
Length.End =Sheet1!$G$1
Length.Start =Sheet1!$D$1

Please Login or Register  to view this content.

This now works. Put in A4 and pull down.

=IF(AND(A4>=$D$1,A4<=$G$1,B3<>""),B3+(A4-A3)*I$1,IF(AND(A4>=$D$1,A4<=$G$1,B3=""),A$4*I$1,""))

If the value in Col A is outside the parameters, Col B is blank.
If it is the first match in Col A, Col B multiplies A4 by the C1 number.
If Col B has a value in the row above, take the value in Col A, deduct the value above it, multiply the difference by the C1 value, and add the value in the previous Col B row

Ochimus.

Try in C4:

Please Login or Register  to view this content.

Drag down.