I used this formula
However, the formula changed whenever I insert new row.
This formula for 2 workbooks.
Before insert:
=SUM([KT.xlsx]First:Last!$D$116)
After insert:
=SUM([KT.xlsx]First:Last!$D$117)
I used this formula
However, the formula changed whenever I insert new row.
This formula for 2 workbooks.
Before insert:
=SUM([KT.xlsx]First:Last!$D$116)
After insert:
=SUM([KT.xlsx]First:Last!$D$117)
Perhaps =SUM(INDIRECT("[KT.xlsx]First:Last!$D$116"))
=SUM(INDIRECT("'[KT.xlsx]First:Last'!$D$116"))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Is the target sheet open and in the same location?
Same sort of thing as your other thread. Open both files in the same location.
=SUMPRODUCT(SUM(INDIRECT("'[SumSource.xlsx]"&$G$1:$G$3&"'!A1")))
No.
Is KT.xlsx OPEN or CLOSED when you try to do the sum. INDIRECT ONLY works on open sheets.
Is it in the same folder as the sheet you are returning the answer to. If not, the full file path needs to be included.
See Post 7.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks