The Wayback Machine - https://web.archive.org/web/20141015160417/http://webapps.stackexchange.com:80/questions/63197/add-cell-from-multiple-spreadsheets-in-google-spreadsheets

current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.
up vote 0 down vote favorite

I have a Google spreadsheet that contains 30 sheets (each day for the month of September). I want to add cell K36 from each sheet, but I don’t know how. How can I do this?

share|improve this question

2 Answers 2

up vote 1 down vote

IF your sheets are numbered 1 to 30 inclusive (eg up to Sheet30), it may be less tedious to insert: 

=indirect("Sheet"&column()&"!K36")

into ColumnA (say Row10), copy that across to AD, then add that row (say =sum(10:10) ) - or do this on a separate sheet and reference the result from there.

share|improve this answer
up vote 0 down vote

Simplest answer:

=Sheet1!K36 + Sheet2!K36 + Sheet3!K36 + Sheet4!K36 + Sheet5!K36 + Sheet6!K36 + Sheet7!K36 + Sheet8!K36 etc

There are other answers based on scripting, which you should investigate if you need a repeatable solution (hint - search for 3D summing). But this will be the quickest approach for a one-off.

share|improve this answer
1  
Mary, I went ahead and approved the edit as it seemed as if you had a typo, but feel free to make any adjustments as you see fit. –  jonsca♦ Jul 7 at 20:36

Not the answer you're looking for? Browse other questions tagged or ask your own question.