Using a variable date to stop Summing when that date is reached

[ltsolis]

Hi

I have a spreadsheet that has a column with Months and a second column with numbers. I want to get the sum of the numbers but only up to the month that I specify in a different cell. It would be somewhat of a running total, but I want it to stop at the month I specify.

For example, I have Jan-11, Feb-11, Mar-11....Dec-11 in one column and each corresponds to a number in a second column. If I enter Jun-11 in an input cell, I want Excel to sum all the numbers but stopping at Jun-11.

Any help would be greatly appreciated.

ltsolis

[JBeaucaire]

You should change your designation to an actual date, like Jun-30-11, that's an actual date.

With that, SUMIF() can do the work. Assuming column A is dates, B is values, and you've entered a date in D3, then this formula in E3:

=SUMIF($A:$A, "<=" & D3, $B:$B)

[ltsolis]

This worked very well.

Thank you very much.

ltsolis