Robo,

This works fine for me. Personally I would use <"" rather than "", but
both worked.

Is the dataset large? Have you tried it on a smaller set? Can you show us
some data?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Robo" wrote in message
...

"=SUMPRODUCT((VP_Active"")*(Revised_Source=$J 10))

I would like to count how many suppliers in the range "Revised_Source"
(Cell J10 is on a summary page for the suppliers) where the value in
the other range VP_Active is anything other than a blank cell. The
blank cell has a formula that returns blank or a value.

Any ideas, this has stumpted me!

Robo


--
Robo
------------------------------------------------------------------------
Robo's Profile:
http://www.excelforum.com/member.php...o&userid=12058
View this thread: http://www.excelforum.com/showthread...hreadid=487880