I apologize for posting this twice - should have just posted the whole question at once. In any this is my problem:
On Sheet 1 I have
Column A - the first year that an expense is incurred (a number betwen 1 and 30)
Column B - a year denoting how many years until it will be incurred again (a number between 1 and 30)
Column C - The expense amount
On Sheet 2 I have
Row 1 - The years (numbered 1 through 30)
In row 2 I want to put a formula that will show the total expenses incurred in that year
As an example
A B C
1 5 $100
2 2 $60
8 8 $50
So in the cell underneath year 6 I want it to return $160 ($100 + $60) and in the cell beneath year 8 I want it to return $110 ($60 + $50)
There could be hundreds of data entries on Sheet 1 so I dont want to have to do an IF statement for every entry. Any help would be MUCH appreciated as I am STUMPED!
Thanks -
On Sheet 1 I have
Column A - the first year that an expense is incurred (a number betwen 1 and 30)
Column B - a year denoting how many years until it will be incurred again (a number between 1 and 30)
Column C - The expense amount
On Sheet 2 I have
Row 1 - The years (numbered 1 through 30)
In row 2 I want to put a formula that will show the total expenses incurred in that year
As an example
A B C
1 5 $100
2 2 $60
8 8 $50
So in the cell underneath year 6 I want it to return $160 ($100 + $60) and in the cell beneath year 8 I want it to return $110 ($60 + $50)
There could be hundreds of data entries on Sheet 1 so I dont want to have to do an IF statement for every entry. Any help would be MUCH appreciated as I am STUMPED!
Thanks -