=SUM( IF( ISNUMBER( SEARCH("FULL",Sheet1!$C$4:$C$7498) ), IF( ISNUMBER( SEARCH("2007",Sheet1!$D$4:$D$7498) ), Sheet1!L$4:L$7498,0 ), AND(Sheet1!$M$4:$M$7498>5) ) )