Sum between two dates

[damhuet]

Hi

In the attached s/s I would like in the column D of the 'Results' worksheet to sum up the data from the D column of the 'Data' worksheet. Cells highlighted in red.

However the condition is the Date of the Dvd should be between the two dates of the 'Results' worksheet. So my total in cell F4 of 'Results' worksheet should be the totql of the data before the 11/06/2009. In F5 it should be the total between the 11/06/2009 and the 21/06/2009.

In 'Results' the expected total is in column F.

I would like the formula to take the whole range of the column C in 'Data' worksheet and to be drilled down.

Thanks for your help

Damien

[daddylonglegs]

Try this formula in D4 copied down

=SUMIF(Data!C:C,">="&C3,Data!D:D)-SUMIF(Data!C:C,">"&C4,Data!D:D)