Hi Dawn

Try
=SUMIF(A7:A15,"=12/04/05",B7:B15)-SUMIF(A7:A15,"14/04/05",B7:B15)

Regards

Roger Govier


dawn wrote:
=SUMIF(A7:A100,"=12/04/05-<=14/04/05",B7:B15) what am i doing wrong