Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create SumIf function for date parameters
Can someone help me in creating a sumif function that will add all the dollar
amounts corresponding to only January's dates. I've tried to use the formula below with no success. Date Dollar January 1, 2007 40 =SUMIF(A2:A10,""=(MONTH(1)),Dollar) January 5, 2007 55 January 9, 2007 56 February 2, 2007 40 February 4, 2007 12 February 14, 2007 78 March 1, 2007 62 March 15, 2007 35 March 6, 2007 45 -- Miroshak |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create SumIf function for date parameters
Try:
=Sumproduct(--(Month(A2:A10)=1), B2:B10) "Miroshak" wrote: Can someone help me in creating a sumif function that will add all the dollar amounts corresponding to only January's dates. I've tried to use the formula below with no success. Date Dollar January 1, 2007 40 =SUMIF(A2:A10,""=(MONTH(1)),Dollar) January 5, 2007 55 January 9, 2007 56 February 2, 2007 40 February 4, 2007 12 February 14, 2007 78 March 1, 2007 62 March 15, 2007 35 March 6, 2007 45 -- Miroshak |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel problem - sumif with multiple parameters | Excel Worksheet Functions | |||
Function Excel:If a Dateactual date create a RED alert in a cel? | Excel Programming | |||
Parameters of SUMIF in VBA | Excel Programming | |||
SUMIF within date range as a function of today()'s date | Excel Worksheet Functions | |||
create function with passing parameters | Excel Programming |