ExcelBanter - Create SumIf function for date parameters

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Create SumIf function for date parameters (https://www.excelbanter.com/excel-programming/402297-create-sumif-function-date-parameters.html)

miroshak

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

JMB

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

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