Sum of data between two dates - tried SUMIF and it returned "0"

[qwopzxnm]

I am trying to sum the data between two dates but when I use the SUMI
function I am getting a result of 0.

I tried using SUMIF(A:A,"<=D2",B:B) and then subtractin
SUMIF(A:A,"<D1",B:B) but both results are giving me a 0 amount.

How could I get the sum of data in B between the dates I calculate i
cells D1 and D2?

D1 = 10/1/04
D2 = 10/5/04


Row A B
1 9/27/2004 10
2 9/28/2004 15
3 9/29/2004 20
4 9/30/2004 25
5 10/1/2004 30
6 10/2/2004 35
7 10/3/2004 40
8 10/4/2004 45
9 10/5/2004 50
10 10/6/2004 55
11 10/7/2004 60
12 10/8/2004 65
13 10/9/2004 70
14 10/10/2004 7

 

[bill k]

have a go at using the sumproduct function

=SUMPRODUCT(--(A1:A14<=D2),--(A1:A14>=D1),B1:B14

 

[Peo Sjoblom]

Try

SUMIF(A:A,"<="&D2,B:B)

do the same for the other