R
raith99
I have a table which changes dependant on ages input on another sheet.
This table starts at the current age and the rows go down to an age i
the future. Both these ages can change so you might have a start age o
50 and an end age of 65, so 16 rows or it could be start 55, end 62 s
only 8 rows.
Column A lists the ages i.e. 50,51,52,53, etc. and then other column
have figures relating to that age such as income in column F.
The problem I have is that I need to sum the income up to the midpoin
so in the first example I need to sum the F column from age 50 to age 5
and in the second from age 55 to 58. I just can't figure out how to d
it.
I've tried various functions over the last few hours but gettin
nowhere.
Any assistance greatly appreciated
This table starts at the current age and the rows go down to an age i
the future. Both these ages can change so you might have a start age o
50 and an end age of 65, so 16 rows or it could be start 55, end 62 s
only 8 rows.
Column A lists the ages i.e. 50,51,52,53, etc. and then other column
have figures relating to that age such as income in column F.
The problem I have is that I need to sum the income up to the midpoin
so in the first example I need to sum the F column from age 50 to age 5
and in the second from age 55 to 58. I just can't figure out how to d
it.
I've tried various functions over the last few hours but gettin
nowhere.
Any assistance greatly appreciated