Hi everyone,
So i tried to use sumif referencing from another workbook.
When i close the workbook the results are #value unless if i open the file again.
is there any suggestions to avoid this error when using sumif?
Hi everyone,
So i tried to use sumif referencing from another workbook.
When i close the workbook the results are #value unless if i open the file again.
is there any suggestions to avoid this error when using sumif?
add all data in 1 workbook, eventualy in differant worksheets.
Last edited by oeldere; 07-19-2020 at 02:53 AM. Reason: differt changed in differant
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
You could use the SUMIF IN the source file, then reference that answer from the destination file?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you all for replying !
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks