Dynamically Adding Table Values

I am creating a spreadsheet that models the sale of some single family homes.

I have built a sale schedule that says X of the homes are to be sold per month, and I am then looking to multiply that X number by the appropriate values (the values are not the same, and range from $300,000-$450,000)

Say I am supposed to sell 4 in the first month, 4 in the second month, and 4 in the last month, and the sale values are as follows:

1 – 300k

2 – 300k 

3 – 300k

4 – 350k

5 – 350k

6 – 350k

7 – 400k

8 – 400k

9 – 400k

10 – 450k

11 – 450k

12 – 450k

Can I create a formula that looks at the number of homes sold in the first month (4), then add up the values 300k + 300k +300k +350k (representing the first 4 homes on the list)

The second month should be relatively similar. 4 homes are to be sold that month, however I would now like to add up home 5 – home 8 values (350k + 350k + 350k + 400k)

And for the 3rd month of 4 homes sold: 400k + 400k + 400k + 450k.

Is there a function that can dynamically add differing table values based on some type of criteria?

Thanks in advance!

By: Peter S.

Leave a Reply

Your email address will not be published. Required fields are marked *