Google Sheet : ImportRange Then Simultance Summing Cell

[muhammad susanto]

hi all..

i'm looking formula to importrange then can simultantce summing in different cell
my target in cell C3, the result shoud be 55+110 = 165

=SUM(IMPORTRANGE("https://docs.google.com/spreadsheets/d/14cgWhnT3H7gWR0SI9ne8rzovW-8Rsc0pVB_-fR9VSeU/edit?usp=sharing","Sheet1!E8;J8"))

here the link sheet

LCK KANWIL RSK JULI 2022 V3 by sst

testing my target, should be 165,note i want importrange with joint sum cell E8+J8 please, see the red cell the result shoud be 55+110 = 165 link data <a href="https://docs.google.com/spreadsheets/d/14cgWhnT3H7gWR0SI9ne8rzovW-8Rsc0pVB_-fR9VSeU/edit#gid=0">https://docs.google.com/spreadsheets/d/...

docs.google.com

and here data link

testing sum with import

Sheet1 Rekapitulasi Capaian Tindak Lanjut Pengelolaan BMN xx No,xx,Pemanfaatan (SEWA, KSP, BGS/BSG, PINJAM PAKAI, KSPI),Pemindahtanganan (PENJUALAN, TUKAR MENUKAR, HIBAH, PMPP/PMN),% Total Persetujuan Yang Telah ditindaklanjuti,Keterangan Jumlah Persetujuan,Tarif Pemanfaatan,Jumlah Tindak Lanjut

docs.google.com

please, see E8 & J8 (red color cell)

across posting

Google Sheet: Sum Combine Import range With Different Cell

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)...

www.excelforum.com

any one help, thank in advance

.sst

 

[jl2509]

Hello

Sheet updated with formula required.

=Sum(IMPORTRANGE("https://docs.google.com/spreadsheets/d/14cgWhnT3H7gWR0SI9ne8rzovW-8Rsc0pVB_-fR9VSeU","Sheet1!E8"),IMPORTRANGE("https://docs.google.com/spreadsheets/d/14cgWhnT3H7gWR0SI9ne8rzovW-8Rsc0pVB_-fR9VSeU","Sheet1!J8"),)

 

[muhammad susanto]

hi jl2509, thank you so much.