Loop through values and sum corresponding values from another sheet

[rebeccagreene]

Hi,

This is my first time posting here, so my apologies if I make any errors!

I have a file with two sheets- Sheet1 of different people's start and end years and Sheet2 of years' corresponding incomes. I would like to loop through each person's start and end year and sum the corresponding years' incomes from Sheet2 into the Sheet1 column Summed Income.
For example, for person 1, whose Start is 2009 and End is 2011, I want Summed Income to take on the sum of the incomes from Sheet2 for 2009, 2010, and 2011, i.e. 930.

I'm not sure if this can be done with just a formula or if it requires VBA, so I'm asking here, but apologies if this is the wrong spot for my question. I've attached a sample file.

Thanks in advance.

[Fluff13]

Hi & welcome to the board.
How about, in E2 copied down
=SUMIFS(Sheet2!B:B,Sheet2!A:A,">="&B2,Sheet2!A:A,"<="&C2)

[maniacb]

Try this VBA code, although this could also be done via formulas. It also computes the elapsed years.

Please Login or Register  to view this content.

[rebeccagreene]

Thank you both!!

[Fluff13]

You're welcome & thanks for the feedback.