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

or

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

but no need for both like

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




--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Carim" wrote in
message ...

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