Better off with SumIf...

E2: 1/1/04
F2: 30/06/04

=SUMIF(A:A,"="&E2,B:B)-SUMIF(A:A,""&F2,B:B)


Bruce Wrote:
I have a worksheet with a column of dates (A) and a column of values
(B).

How can I SUMIF between a date range.

Eg Sumif ( A 1/1/04 < 30/06/04, B)

In other words what is the total of values between this date range?

Bruce


--
Aladin Akyurek
------------------------------------------------------------------------
Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165
View this thread: http://www.excelforum.com/showthread...hreadid=320327