Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use the "SUMIF" function using dates as a condition
I am trying to create a SUMIF formula, but using dates as the control
condition, i.e. I have a column of dates (column A) and I have a corresponding column of dollar figures (column B). I want to create a SUMIF formula where dollar amounts of certain dates are added up. Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use the "SUMIF" function using dates as a condition
Try something like the following:
=SUMIF(A1:A10,DATE(2006,1,13),B1:B10) -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Brit." wrote in message ... I am trying to create a SUMIF formula, but using dates as the control condition, i.e. I have a column of dates (column A) and I have a corresponding column of dollar figures (column B). I want to create a SUMIF formula where dollar amounts of certain dates are added up. Thank you. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I use the "SUMIF" function using dates as a condition
as an example
=SUMIF(A:A,--"2005-01-13",B:B) or =SUMIF(A:A,DATE(2005,1,13),B:B) If you want a date range, use =SUMPRODUCT(--(A1:A100=--"2005-01-01"),--(A1:A100<=--"2006-01-31"),B1:B100) -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Brit." wrote in message ... I am trying to create a SUMIF formula, but using dates as the control condition, i.e. I have a column of dates (column A) and I have a corresponding column of dollar figures (column B). I want to create a SUMIF formula where dollar amounts of certain dates are added up. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Recogniziting Dates in an IF function? | Excel Worksheet Functions | |||
IF function to blank without getting #value in sum function | Excel Worksheet Functions | |||
Finding dates within a date range | Excel Worksheet Functions | |||
Finding Dates in a date range | Excel Discussion (Misc queries) |