Hello David,

You can do that like this

=SUMIF(A:A,"<"&DATE(1999,12,31),B:B)

where dates are in column A and amounts to sum in column B

or you can put your date in C1 and use

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



"David" wrote:

Hi Group,

Having a little trouble doing a SumIf, have a list of dates and a column I
am trying to sum if the date is less than a certain date. The dates go back
to 1/1/1999 and I want to sum value that are less than 12/31/1999, as an
example.

Thanks,
David