Some functions do not work unless the referenced workbook is open. COUNTIF()
is one of those that doesn't. I suggest that you rewrite using the MATCH()
function instead.

The other option is to open up all referenced workbooks and then use Save As
and save as a Workspace instead of individual workbooks. That will insure
that all referenced workbooks are open each time that you open the workspace
in the future.

"Micayla Bergen" wrote:

i have this formula
=IF(COUNTIF(Path/Stocks'!$B$10:$B$413,A4),"S",IF(COUNTIF('Path/Income
securities'!$B$10:$B$413,A4),"FI",IF(COUNTIF('Path/Property &
Infrastructure'!$B$10:$B$413,A4),"PI","None")))
i want S, FI or PI to be returned depending on where the value in A4 is
found, but i get a value message.
Please help.
thank you