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 SUMIF function I am getting a result of 0.

I tried using SUMIF(A:A,"<=D2",B:B) and then subtracting 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 in 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 75

[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


--

Regards,

Peo Sjoblom

"qwopzxnm" <qwopzxnm.1xfa6b_1130184345.3762@excelforum-nospam.com> wrote in
message news:qwopzxnm.1xfa6b_1130184345.3762@excelforum-nospam.com...
>
> I am trying to sum the data between two dates but when I use the SUMIF
> function I am getting a result of 0.
>
> I tried using SUMIF(A:A,"<=D2",B:B) and then subtracting
> 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 in
> 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 75
>
>
> --
> qwopzxnm
> ------------------------------------------------------------------------
> qwopzxnm's Profile:
http://www.excelforum.com/member.php...o&userid=27557
> View this thread: http://www.excelforum.com/showthread...hreadid=478902
>