| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
reference #value error
I am using =COUNTIF(('[01.xls]Managers Page 1'!$D$19:$D$49),901), which looks
at 12 different workbooks that represent 12 months, and looking for a specific code (the "901"), and trying to count the number of times it is used. The problem is unless I have all the workbooks open, I get a #value error. Am I using the wrong formula or is there something else I need to do? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart User Template Error Bars Reference | Charts and Charting in Excel | |||
| IF formula reference error | Excel Discussion (Misc queries) | |||
| Maddening reference error | New Users to Excel | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Linear Mode
