ExcelBanter - Counting cells from one workbook to another

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Counting cells from one workbook to another (https://www.excelbanter.com/excel-worksheet-functions/139438-counting-cells-one-workbook-another.html)

Counting cells from one workbook to another

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.

RagDyeR

Counting cells from one workbook to another

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.

All times are GMT +1. The time now is 09:30 AM.