I have 2 sheets in this Excel spread sheet. One is called "Main" and the
other "Resolve". I have already figured out a formula that I am using on
the main page to look at the "Resolve" sheet and count how many of each
versions we currently have with the below formula:

=COUNTIF('RESOLVE'!D2:D196,"V2")

now what I would like to do is look at all "V2" and to see if the RFI
field associated with each "V2" has a value in it and count those up. I
was trying to use the below formula:

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

This doesn't seem to be working. Can anyone please help me out with
this. Thanks!

-kilikab


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