| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I add cells from multiple worksheets
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. |
|
#2
|
|||
|
|||
|
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 "helpingout" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
| how do i add the same text after current text in multiple cells | Excel Discussion (Misc queries) | |||
| Assigning Cells in worksheets to other data in other worksheets. | Excel Discussion (Misc queries) | |||
| background formatting across multiple cells | Excel Discussion (Misc queries) | |||
| How do I retrieve data (specific cells) from multiple worksheets on a shared drive | Excel Worksheet Functions | |||
Hybrid Mode
