Value#

[richblake74]

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!

 

[JE McGimpsey]

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:E400
0)
I am getting the #Value!

Works fine or me. Do you have a #VALUE! error in your data on sheet Log?

 

[richblake74]

yes I still get the #Value error,, works fine in my other office 2004
its really strange