Sum Columns using vlookup

[mactoolsix]

Creating a retirement spreadsheet. I need to get the annual average of other income (2 columns) from retirement age through life expectancy.

Of course the retirement age is variable depending on the client.

I couldn't figure out how to attach a sample, so I'll attempt to describe it here:

Column C: clients age from 33 to 89
Column D - F: does not pertain to this
Column G: Bus & other income
Column H: Social Security benefits
Rows 10 thru 67 is by age

Client retirement age is 60 (row 38)
I need to sum columns G & H from Age 60 to 89 (rows 38-67). Then I can simply divide by the # of retirement years.

How can I get the sum of these columns from retirement age to final age using vlookup?

THANKYOU in advance!

 

[mactoolsix]

Creating a retirement spreadsheet. I need to get the annual average of other income (2 columns) from retirement age through life expectancy.

Of course the retirement age is variable depending on the client.

I couldn't figure out how to attach a sample, so I'll attempt to describe it here:

Column C: clients age from 33 to 89
Column D - F: does not pertain to this
Column G: Bus & other income
Column H: Social Security benefits
Rows 10 thru 67 is by age

Client retirement age is 60 (row 38)
I need to sum columns G & H from Age 60 to 89 (rows 38-67). Then I can simply divide by the # of retirement years.

How can I get the sum of these columns from retirement age to final age using vlookup?

THANKYOU in advance!

OK - I think I found an easy solution:
Created another column (I) which sums each row if Col C is over the retirement age.
Then I simply get the average of column I if ">0"