How do I add cells from multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How do I get totals from several different worksheets on to one? 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
calculate cells over multiple worksheets 4
Sum Multiple Worksheets, same named cell 1
How do I find like data in multiple worksheets? 1
Totaling cells in multiple worksheets 4

Back
Top