andyp161 Wrote:
Using the below formula, #VALUE! is returned:
=SUMPRODUCT(--(MONTH(Log!$A$2:$A$200)=MONTH(Stats!$D1)),--(Log!$D$2:$D$200=(Stats!$A3)))
I think it is because Log! is linked to a 3rd sheet and contains
ISBLANK as below:
=IF(ISBLANK(Benefit_Plan_Review_Log.csv!$N2),"",Be nefit_Plan_Review_Log.csv!$N2)
Is there anything I can do?
Many thanks
Andy
Are the dates in Colmn N true date values?
Hope this helps!
--
Domenic
------------------------------------------------------------------------
Domenic's Profile:
http://www.excelforum.com/member.php...o&userid=10785
View this thread:
http://www.excelforum.com/showthread...hreadid=383154