I think I now see your problem. The criteria is part of a list. Is the
desired always the 1st 4. How about more examples
maybe

left(yourrange,4)={"TECO","CLSD"}


--
Don Guillett
SalesAid Software

"vipa2000" wrote in message
...
Hi Don, not too sure what you mean. I can't see how this works.
--
Regards vipa


"Don Guillett" wrote:

try adding another parameter of
yourrange={"TECO","CLSD"}

--
Don Guillett
SalesAid Software

"vipa2000" wrote in message
...
I know sumproduct won't work with wildcards, but i need to use
something
that
allows me to do this.



=SUMPRODUCT(--(Sheet1!$C$2:$C$30000=1),--(Sheet1!$D$2:$D$30000=""),--(MONTH(
Sheet1!$I$2:$I$30000)=F2),--(YEAR(Sheet1!$I$2:$I$30000)=H2))

The above works fine thanks to a lot of help from Bob. However I now
need
to
expand the formula so that it will look for the word TECO or CLSD in a
cell.

The cell can contain data in this format

TECO PCNF PRT NMAT PRC SETC

I have tried a number of things to no avail. Help appreciated.

--
Regards vipa