| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a "SUMIF" based upon a Date Range? | Excel Worksheet Functions | |||
| Sumif....date in table is greater than compared to date | Excel Discussion (Misc queries) | |||
| condition sumif commands based on date range? | Excel Discussion (Misc queries) | |||
| Sumproduct based which also weights data based on date | Excel Worksheet Functions | |||
| sumif based on date | Excel Worksheet Functions | |||
Linear Mode
