Here's what to do, assume the table is called MyTable and the header for the
column you want to sum is called Amounts, and the header for the dates is
called Dates, if you use E1:F2 as criteria it would look like


Dates Dates
="=01/01/2006" ="<=02/28/2006"

then the formula

=DSUM(MyTable,"Amounts",E1:F2)

will sum for Jan & Feb of 2006



--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"duncan79" wrote in
message ...

I cant work out what expression i would use to make a DSUM function
count only Figures from certain months.... what expression would i use
in the criteria areas with a date header???? (a pivot table doesnt
really suite my needs.)


--
duncan79
------------------------------------------------------------------------
duncan79's Profile:
http://www.excelforum.com/member.php...o&userid=30833
View this thread: http://www.excelforum.com/showthread...hreadid=543320