Sumproduct Syntax issue

Hello All.

I have a Syntax issue. Or Should I say that I hope that a Syntax issue is all that it is. I am working in Excel 2010 on Windows 7.
Here is my formula

=SUMPRODUCT(('PROJECT NAME Tickets'!U:U=3)*('PROJECT NAME Tickets'!S:S="DAL")*('PROJECT NAME Tickets'!K:K="Stage"),--('PROJECT NAME Tickets'!H:H<="*"&locks for Data sync&"*"))

My issue is with the very last section of it.
('PROJECT NAME Tickets'!H:H<="*"&locks for Data sync&"*"))

What I am attempting to do is to look into all cells in the H column of the 'PROJECT NAME Tickets' worksheet within the same work book. I am trying to only count the cells that have the phrase "locks for Data sync" within the text that is in the cells in the H column.

I have tried all of the following -
('PROJECT NAME Tickets'!H:H<="*"&locks for Data sync&"*")) Kicks back error = #NAME?
('PROJECT NAME Tickets'!H:H>="*"&locks for Data sync&"*")) Kicks back error = #NAME?
('PROJECT NAME Tickets'!H:H="*"&locks for Data sync&"*")) Kicks back error = #NAME?
('PROJECT NAME Tickets'!H:H="*""&locks for Data sync&""*")) Kicks back a False "0" ( the correct count is 14)
('PROJECT NAME Tickets'!H:H="*"locks for Data sync"*")) Kicks back a False "0" ( the correct count is 14)

('PROJECT NAME Tickets'!H:H="*""&locks for Data sync""*")) Kicks back a False "0" ( the correct count is 14)

Thank you for your Time
Tim

I have also changed the connectors from )*( to ),--( without any change to the results.

Thank you both for your quick responce...

With the =COUNTIFS('PROJECT NAME Tickets'!U:U,3,'PROJECT NAME Tickets'!S:S,"DAL",'PROJECT NAME Tickets'!K:K,"Stage",'PROJECT NAME Tickets'!H:H,"*locks for Data sync*")

I am getting "You've entered too few arguments for this funtion"

I am trying Martin's now and will post the results.

Martin, I am getting the #NAME? error on yours. I am going over my text carefully to verify it is not an error on my part.

Martin, I'm sorry... I am getting the #VALUE? error on yours. Not the #NAME?.

If I change Martins formula to show H:H I then get the False "0" reading...

The closest that I could come with the =COUNTIFS:

is =COUNTIFS('Project Tickets'!U:U,3)*('ProjectTickets'!S:S="DAL")*('ProjectTickets'!K:K="Stage")*('ProjectTickets'!H:H="*locks for Data sync*") and this is after Excel "Fixed" the formula for me.

If I ran it the way it was given it will return a ........ WAIT!!!!

IT WORKED!!!!! I re ran it with a small change. the last ) was green and I deleted it and re placed it and it worked!!!!

Thank you both so much for your time!!