my date range does not work in an = ifsum

[dawn]

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

 

[Roger Govier]

Hi Dawn

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

Regards

Roger Govier