SumIf based on date
Perfect! Thank you so much.
--
Thanks,
Harry
"bapeltzer" wrote:
=sumif(b:b,"<=" & k1,c:c)
This assumes that you only have dates (not dates w/ times) in column B.
"Harry" wrote:
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
|