Hi,

I have a formula - "=sumproduct(--MONTH(Spreads!$S$5:$S)=12)".

This formula goes to the "Spreads" worksheet and looks for all instances that equal the month of Dec. However, right now, there are no instances, but it's returning the number of 984. I have this for Jan - Dec and the rest of the months appear to work fine, just dec is not correct. Thank you.