Hi,

So I have a data sheet where one column has numbers, second column has dates.

The second column has dates on only some of the columns.

For example:


Column 1
16
12
5
-7
10
-5


Column 2
4/1/2012
(empty)
(empty)
7/17/2012
(empty)
8/4/2012


What I'm trying to do is use a SUMIF statement to add up the numbers for each date up to the next date listed.

So the result on column 3 should look like

33
(empty)
(empty)
3
(empty)
-5



Is there a way to do this with one formula? I need to use this formula on many cells and would like to keep a running formula to sum any numbers until the next date listed.

Thanks for your time!