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)
2
votes
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.
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.OkRead more