If the values are in C27:C30 as mdbct suggests then you could use this form

=SUMPRODUCT(--ISNUMBER(MATCH('2009 Pipeline'!$K$4:$K$64,Summary!$C$27:$C$30,0)),--('2009 Pipeline'!$M$4:$M$64=$B$29),--('2009 Pipeline'!$A$4:$A$64=Summary!$A30),'2009 Pipeline'!$J$4:$J$64)