| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting cells that are 0 in a range of non-contiguous cells | Excel Worksheet Functions | |||
| Counting the number of Worksheets in a Workbook | Excel Worksheet Functions | |||
| Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
Linear Mode
