| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
question about formula based on another workbook info
I should have said
=SUMPRODUCT(('C:\yourfolder\[yourfilename.xls]yourworksheet'!$B$5:$B$9="SF")*1) -- Don Guillett SalesAid Software "Treesy" wrote in message ... I am trying to use the CountIF function in Workbook A that counts info in a range of cells located in Workbook B. I'd like Worksheet A to update when changes to Worksheet B is made. But the function only works if Workbook B is open, otherwise I get the dreaded #VALUE! error. What am I doing wrong? Thanks!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I get error with "ROWS" in the formula - nested formula question | Excel Worksheet Functions | |||
| How do I set a cell value based on a formula in another cell? | Excel Discussion (Misc queries) | |||
| can i create formula giving totals based on financial & text info | Excel Discussion (Misc queries) | |||
| formula based on text information | Excel Worksheet Functions | |||
| Formula Question | Excel Discussion (Misc queries) | |||
Threaded Mode
