[moved] Help with speadsheets

BulldogVII · Blue Pill Joined: Jul 07, 2008 Posts: 1

Hi all

Not sure if this is the correct forum to ask for help??

I'm not that conversant with spreadsheets, I can add column up & that's about it.

Is is east to add a column up (I know how to do this) & then transfer the answer to another sheet??

Any help or a point in the right direction would be appreciated

Thanks

yoxi · Posted: Mon Jul 07, 2008 2:28 pm Post subject:

(Moved this thread to the Support forum...)

You can refer to a cell in a specific sheet using the format SheetName.CellReference - so for example if you want the sum of the cells A1 to A5 from Sheet1 to appear in cell A1 of Sheet2, the formula to put in cell A1 of Sheet2 is:

=SUM(Sheet1.A1:A5)

I hope this is what you're looking for.

- padmavyuha

philipnb · Blue Pill Joined: Jul 21, 2008 Posts: 1

Hi, I am new to this forum and am trying to do the same thing but I am getting #NAME? or #REF errors.

I am doing a financial spreadsheet. I have sheets called Personal Expenses, Business Expenses 1 and Business Expenses 2. I want to pull some totals from each of those 3 sheets into one called Global Budget. I want to be able to refer to a cell that has a sum in it.

1. Can I do that or do I need to use the solution above and "re-add" them using the formula

2. The sheet name that I entered into the Global Budget cell was =Personal Expenses.B34. This gives me the #Name? error. I thought that perhaps the space in the name was a problem so I removed it, which gave me the #REF error.

3. I also tried =SUM(Personal Expenses.B5:B32) which gave the #NAME? error as well.

Are the spaces in the sheet name a problem or is there something else I need to do?
Thanks.

pluby · The Architect Joined: Jun 16, 2003 Posts: 11949