Google Sheet: Sum Combine Import range With Different Cell

[Jhon Mustofa]

hi all...

i,m looking for formula to sum value combine with import range with different spreadsheet
in sheet "5. TL Pengelolaan BMN" in cell only E8 plus J8 . ....(E8+J8)

=SUM(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1wIVt13K-AGR73Fs9RFECNMhVImqsCvjHHsneIdBgN6s/edit#gid=1311488025","5. TL Pengelolaan BMN!E8;J8"))
that not work to sum

how to fix this problem
here link
https://docs.google.com/spreadsheets...#gid=642648765

thanks in advance

john m

[janmorris]

The sheet you linked to isn't publicly accessible. For us to help in the file, you'll need to*set the Share settings*so that Anyone with the link has*Editor*rights.

Steps to share a file:
Click the Share button at the top right of your file
Once the sharing window opens, under General access, switch Restricted to Anyone with the link
Once the setting refreshes, change Viewer to Editor
Click Done

Please let us know once you've done this, and we'll take a look at the issue.

[Jhon Mustofa]

hi janmorris...
i,m sorry , he new link

https://docs.google.com/spreadsheets...it?usp=sharing