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