"=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