Try this:

=SUMPRODUCT((Oranges!A3:A5000=500400)*(Oranges!P3: P5000<""))

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"VW" wrote in message
...
Example, in workbook "Apples", column B3, I want to count what is in
workbook
"Oranges", column P3:P5000 if in workbook "Oranges", column A3:A5000
contains
the number 500400. Please help.