Help with SUMPRODUCT
 

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

Help with SUMPRODUCT
 

Also, forgot to mention, the formula does bring back a result but it
seems to be adding another name range!

Most strange!


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

Help with SUMPRODUCT
 

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

Help with SUMPRODUCT
 

can I e-mail you the spreadsheet? Its not big


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

Help with SUMPRODUCT
 

I have crack it! The guy had a space between " ". and I was looking for
""

Thanks for your help

Robo


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