=SUMPRODUCT((A1:A8="Europe")*(MONTH(B1:B8)=10)*(C1 :C8))

should do it


--
Alex Delamain
------------------------------------------------------------------------
Alex Delamain's Profile: http://www.excelforum.com/member.php...o&userid=11273
View this thread: http://www.excelforum.com/showthread...hreadid=222618