Is it possible to range over sheets in one spreadsheet ?
Ive got sheets: S, A, B, C, D. In S I would like to do (for some cell C4):
=SUM(A:D!C4)
To sum C4 in A, B, C, and D. It is doable in google spreadsheet at all ?
You just need to mention the sheet names as well. Though, you'll have to mention each sheet name seperately. Something like this would work
=SUM(A!C4, B!C4, C!C4, D!C4)
I think the answer to this is that it isn't possible on google sheets as yet.
Would love if Sheets actually had similar functionalities.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With