CODEWITHSUNDEEP
google-sheets
Darek
Darek

Reputation: 2921

Sum range over sheets in google spreadsheets

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 ?

Upvotes: 24

Views: 46154

Answers (2)

bolong
bolong

Reputation: 31

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.

Upvotes: 3

Chris
Chris

Reputation: 868

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)

Upvotes: 30

Related Questions