I need a formula that looks at three different cells with dates in two of the
cells and a dollar amount in the other that will give a cumulative total over
time if column d is before column F. For example: D10=3/27/2006 and
F10=5/3/2006 and E10=609,214. Since D10 is before F10, cell P10 would equal
609,214. Now, if D11=4/14/2006 and F11=4/12/2006 and E11=5,055,000 then cell
P11 would still =609,214, because D11 is after f11. Column D10 and F10 have
dates down to row 17 and column E has dollar figues down to row 17. I have
tried the following
=SUMPRODUCT(--($D$10:$D$17<=F10),$E$10:$E$17)