Assuming your columns of data are all the same length you can use this
formula


Code:
--------------------

=SUMPRODUCT((MONTH(A1:A10)=6)*(YEAR(A1:A10)=2005)* (B1:B10="L.A.")*(C1:C10))
--------------------


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=567248