Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Thanks for the last answer now another one please
Like I said I just got the 2008 version, is Sumproduct in the Add Ins.
As the below formula worked great in the 04 version.
What is going wrong?
Thank u
=SUMPRODUCT(--(MONTH(Log!A3:A4000)=$A2),--(YEAR(Log!A3:A4000)=C$1),Log!E3:E4000)
I am getting the #Value!
