Counting cells from one workbook to another

G

Guest

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.
 
R

RagDyeR

Try this:

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

--

HTH,

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Nested formula...I think 1
Multi column sumproduct 3
Data entered from list automatically enters number in another cell 4
match, lookup two column data 10
Summing/Counting Data in One Column Based on Criteria Another Col 2
INDEX PROBLEM...I THINK 15
Autogroup then sum - can it be done? 5

Top