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

Sorry Andy! I just re-read your post and it looks like I misunderstood
the situation. Try the following formula instead...

=SUM(IF(Log!$A$2:$A$200<"",(MONTH(Log!$A$2:$A$200 )=MONTH(Stats!$D1))*(Log!$D$2:$D$200=Stats!$A3)))

...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

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