Hi,

Not sure what's wrong with my formula, but it's returning a #value. Any ideas best formula to return a value when looking at months. I believe both dates are in the same format. (if there are not, is there something in formula to bypass that part)?

=SUMPRODUCT((MONTH($B$52:$B$1528)=MONTH(AB1))*($E$52:$E$1528))
Thanks