Hi,

=SUMPRODUCT(('RESOLVE'!D2:D196=V2)*--('RESOLVE'!I2 :I196<""))

I am guessing column I is a column with non numeric entries ...

HTH
Cheers
Carim


--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=532783