Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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 ?

like image 892
Darek Avatar asked Jan 12 '14 22:01

Darek


2 Answers

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)

like image 76
Chris Avatar answered Oct 06 '22 13:10

Chris


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.

like image 45
bolong Avatar answered Oct 06 '22 14:10

bolong