sum using year and between months

[elmasguapo]

Hello. I have data across three years. I have three cells. Years and start month/end month. How can I write a formula that will sum based on this criteria? Spreadsheet attached. Thanks!!

[canapone]

Hi,

=SUMPRODUCT(A3:AJ3,(YEAR(A2:AJ2)=AL1)*(MONTH(A2:AJ2)>=MONTH(AL2&1))*(MONTH(A2:AJ2)<=MONTH(AM2&1)))

if you could write 1 instead of January and 4 insead of April:

=SUMPRODUCT(A3:AJ3,(YEAR(A2:AJ2)=AL1)*(MONTH(A2:AJ2)>=AL2)*(MONTH(A2:AJ2)<=AM2))

Hope it helps

[elmasguapo]

@ canapone. That worked!! Thanks