Hi,
Can someone tell me if there is something wrong with the below function I'm using.. It keeps returning #VALUE!.
A2:A50 on the Weekly Stats sheet contain a date.. It's driving me nuts..
Using Excel 2007.
=SUMPRODUCT(--MONTH('Weekly Stats'!A2:A50)=1)
Bookmarks