Hi,

Am Fri, 19 Oct 2012 11:06:07 -0700 (PDT) schrieb :

currently using
=SUMPRODUCT((R1:R25='CONTRACT VENDORS'!A3:A712)*1)
try:
=SUMPRODUCT(--('Contract Vendors'!$A$3:$A$712=R1),--('Contract
Vendors'!$A$3:$A$712<""))
or:
=COUNTIF('Contract Vendors'!$A$3:$A$712,R1)


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2