| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Break this down...
Did you record a macro to add the reference to the new workbook or did you
try to modify the code that you have? In either case post the code that you have... If you want to do a CountIf to a seperate workbook I think you might run into an issue if the externally referenced workbook is closed because CountIf doe not like referencing closed books. Take a look at this web site... http://www.xldynamic.com/source/xld.SUMPRODUCT.html -- HTH... Jim Thomlinson "CV323" wrote: Ok makes sense now. I was confused on that C. I realized that I got the info while the sheets were on the same workbook. What if the info is in another workbook? It comes back saying that I entered too few arguments. Is it not possible to "=countif" with the data in two separate workbooks? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 Page Break Adjustments causes a page break each cell | Excel Worksheet Functions | |||
| Break a link between workbooks when there is no "break" option | Excel Discussion (Misc queries) | |||
| Break cell into multiple lines by line break | Excel Discussion (Misc queries) | |||
| adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
| Can Not Get Macro to Break with CTRL-BREAK | Excel Programming | |||
Threaded Mode
