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

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

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

have a go at using the sumproduct function

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


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=478902

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

Try

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

do the same for the other


--

Regards,

Peo Sjoblom

"qwopzxnm" wrote in
message ...

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