There could be several reasons for that:
- Your external file needs to be open for a result to be displayed.
- Your range is rather large - are you sure that there are only proper
integer values in that range, and not some text or error values?