Function help, summing multiple variables, VLOOKUP?

[jd92]

I'm looking for a function that will sum multiple figures when a date (month), is the input variable. For example when I type a specific month into cell "D5" I would like the sum of all months less than and equal to the specified date taken from "M7:M366". If I query 250 I'm looking for the sum of month 1-250. I tried vlookup, but that only provides the specific date queried.

I attached the spreadsheet that I'm working with

Any help much appreciated!!

 

[Nebu]

Hi:
Is this what you are looking for?

Thanks

 

[jd92]

Hi:
Is this what you are looking for?

Thanks

Very close! I'm trying to determine ownership for a number of parties; I see that included in your function you use cell "D5" and "D6" to specify the months. Is there a way to do this within one cell say months 1-250 in "D5" and also the same in other cells?
Thanks!

 

[Nebu]

Hi:

I did not understand what you want, can you upload a workbook with expected results.

Thanks

 

[jd92]

You're function is pulling the correct data that I needed, Is there a way to make it so that the function is tied to only one cell instead of two. Your formula is based off of what numbers are entered into "B8" and "B9", can it be linked to one cell instead of the two. If I enter month 360 into cell "B8" it pulls the same data?

Thanks!

 

[Nebu]

Hi:

If your start period is always going to be 1 then you can use the following formula
=SUMIF($G$3:$G$362,"<="&$B$9,$K$3:$K$362)/2

But this will not be flexible as the previous formula where you can calculate values between any given period.

Thanks

 

[jd92]

Hi:

If your start period is always going to be 1 then you can use the following formula
=SUMIF($G$3:$G$362,"<="&$B$9,$K$3:$K$362)/2

But this will not be flexible as the previous formula where you can calculate values between any given period.

Thanks

You rock!!

Much appreciated!