ExcelBanter - SumIf based on date

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - SumIf based on date (https://www.excelbanter.com/excel-discussion-misc-queries/227447-sumif-based-date.html)

Harry

SumIf based on date

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

bapeltzer

SumIf based on date

=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

T. Valko

SumIf based on date

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

Harry

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

All times are GMT +1. The time now is 10:17 AM.