Thanks, that did the trick!

daddylonglegs wrote:
Bob,

I presume you meant to use SEARCH not MATCH

=SUMPRODUCT(--(LEFT('Data S
Opened'!N2:N65536,10)="dlo-NL-HDK")--ISNUMBER(SEARCH("Concernstaf",'Dat
SD Opened'!T2:T65536))

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200602/1