[Solved] Multiple tabs computations

[jherkimer]

Good morning,
We are new to Calc and attempting to create spreadsheets for our food co-op buying club members. There is one spreadsheet/tab for each member, with a final spreadsheet/tab for the entire club's figures.

Despite searching the various FAQs and forums, we have not been able to ascertain how to compute figures from the members' spreadsheet on the final "master" spreadsheet.

Is it possible to enter a formula in the "Sum" window of our "master" spreadsheet that is able to simultaneously gather and calculate figures from all our members' spreadsheets?

We are a bit apprehensive and intimidated to post because your skill levels are far beyond ours. Thank you in advance for assisting a couple of neophytes!

Judy & Joanne

[jrkrideau]

Yes you can do it. At the simplist you just need to do something like
=SUM(Sheet1.A1;Sheet2.A1;Sheet3.A1) which adds up the cell A1 for tabs 1, 2 & 3.

You can either type in the references (fast but prone to typing errors) or just go to each tab and click on the cell you want to enter in the equation. If you use the point and click approach you need to manually enter the ";"

Y

[jherkimer]

Dear Rideaujrk,
Kind thanks for your swift response and solution to our problem.

Judy & Joanne

[Villeroy]

Alternatively =SUM($Sheet1.$A$1:$Sheet3.$A$1) sums all A1 from sheet1 to sheet3. You may have a look at Menu:Data>Consolidate... to aggregate results of disjunct ranges.