On Tue, 31 May 2005 15:59:24 -0700, "Bryan Brassell" <Bryan
wrote:

Need to have both "12/31/2004" and "<02/01/2005" as criterion in a sumif.

=SUMIF(range, "" & DATE(2004,12,31), sum_range) -
SUMIF(range,"=" & DATE(2005,2,1), sum_range)

or (which seems slightly more clear to me, assuming you want data from Jan
2005):

=SUMIF(range, "=" & DATE(2005,1,1), sum_range) -
SUMIF(range, "" & DATE(2005,1,31), sum_range)


--ron