|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
April 12th, 2009, 05:40 PM
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
April 12th, 2009, 05:46 PM
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
April 12th, 2009, 05:50 PM
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
April 12th, 2009, 06:03 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
