Formula for cell to get information from other worksheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

new2excel - 01 May 2008 06:48 GMT

I am keeping track of our school's jog-a-thon with Excel. I have created a
workbook, where every worksheet is a classroom. At the bottom of each
worksheet I have a cell that has a formula adds all the money up for that
class.

The last worksheet page is a totals page. What formula do I put in the
cells to get the information from the other worksheet pages? Is there a
formula that I can put in there, so that it will update when we enter new
information in the worksheet pages?

Reply to this Message

Bob Phillips - 01 May 2008 08:50 GMT

simply reference a cell with the sheet id, such as

='Class 7A'!H10

If you do the summary of each class into cells on its own sheet, you can
then pick up that summary directly on the master sheet, and do further
aggregations there.

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

>I am keeping track of our school's jog-a-thon with Excel. I have created a
> workbook, where every worksheet is a classroom. At the bottom of each
[quoted text clipped - 5 lines]
> formula that I can put in there, so that it will update when we enter new
> information in the worksheet pages?

Reply to this Message