Help with SUMPRODUCT

[Robo]

"=SUMPRODUCT((VP_Active>"")*(Revised_Source=$J10))

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 i
the other range VP_Active is anything other than a blank cell. Th
blank cell has a formula that returns blank or a value.

Any ideas, this has stumpted me!

Rob

 

[Robo]

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

Most strange

 

[Bob Phillips]

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]

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

 

[Robo]

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

Thanks for your help

Robo