Try this:

=SUMIF(B1:B20,"<="&K1,C1:C20)

--
Biff
Microsoft Excel MVP


"Harry" wrote in message
...
I have dates in Col B, and quantity in Col C. I want to enter a date in
cell
K1, and have the quantities added in Col C that occurred on or before the
date in K1.
--
Thanks,
Harry