How do I add cells from multiple worksheets

G

Guest

I am making a stat program for my husband's basketballteam. I am putting
each game on a new worksheet. How can I add up a coloumn from every sheet
and putit into a column on my "totals" worksheet?
Any help woul dbe greatly appreciated.
 
J

JulieD

Hi

if you have
sheets called game1, game2 ... game 12

on the summary sheet you could have
in cell A2 the word Game 1 and then in B2 something like =game1!B10
or in cell A2 you could have Total Scores to date and then in B2
=SUM(game1:game12!B10)

hope this helps

Cheers
JulieD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I insert a drop down calendar in spreadsheet? 1
How do I find like data in multiple worksheets? 1
How do I get totals from several different worksheets on to one? 1
Linking Totals Across Multiple Worksheets 2
Cells across multiple sheets 6
Countif Formulas 2
Calculating daily totals from multiple worksheets (Excel 2003) 4
Totaling cells in multiple worksheets 4

Top