srizki
Wellknown Member
 Joined
 Jan 14, 2003
 Messages
 1,791
 Office Version

 365
 2016
 Platform

 Windows
I have dates in column I, amount is column J
I am using formula,
'=SUMIFS(J2:J217,I2:I217,">="&DATE(H221,MONTH(I221&" 1"),1),J2:J217,"<="&DATE(H221,MONTH(I221&" 1"),30))
Where H221 has dropdown year and I221 occupies drop down months.
the formula is giving wrong results.
Regards
Sohail
I am using formula,
'=SUMIFS(J2:J217,I2:I217,">="&DATE(H221,MONTH(I221&" 1"),1),J2:J217,"<="&DATE(H221,MONTH(I221&" 1"),30))
Where H221 has dropdown year and I221 occupies drop down months.
the formula is giving wrong results.
Regards
Sohail