Find a value on a row and sum the values below till a certain point

what is "LE" in column "B" and how affects this the Outflow AK8:AK63. AK means the policy number but why does it start at 8 and finish at 63?

LE is the months we're going to pay the premium. In the case I used as example, we're going to pay the premiums for 63 months so the formula would have to sum AK8:AK70 (sorry, 63 was a typo)

I added a named Range for sheet outflow: Policy = =Outflow!$A$7:$AX$7

Please Login or Register  to view this content.

see attached workbook

cheers

I don't know how you did that but it worked! Thank you so much!

for sum you need a range
with offset you define a reference cell and row=0, column=0 and height=LE (length is not needed), reference address has the first value
so you now must get the correct reference address (something like "Outflow!AK8:AK70")

this can be done with indirect() (address consist of sheetname, row=8 (first value), and column which you find with match.

that's it

I did it on my original spreadsheet and it worked! Thank you SO MUCH for your help!