Any Excel nerds in here?

Vaheed1 · 09-03-2012, 09:49 AM

Afternoon all.

I'm wondering if anyone can advise me on this: I'm using MS Excel 2011 on a Macbook Pro. I have 52 sheets of data opened on the same workbook and would like to total data up from 1 particular box into a summary sheet at the end. Does anyone have any quick formula's that don't require me to go through every god damn sheet, manually adding them? Wouldn't be so bad if I had a separate mouse - but it's a complete ball ache on a tracker pad.

I've googled it - but none of the suggestions help.

Thanks.

Vaheed1 · 09-03-2012, 09:52 AM

Don't worry chaps, I've worked it out.

=SUM (<sheet number>:<sheet number>!<cell number>)

Mani59 · 09-03-2012, 10:01 AM

You could just amend the sheet number on the formula.
Eg:

=Sheet1!A1+Sheet2!A1 etc.

EDIT:

You got it

kaishang · 09-03-2012, 10:06 AM

You could just sub-contract it to a data centre in India

MEGA · 09-03-2012, 10:17 AM

Any reason you felt the need to mention you were on a macbook pro?

makkan00 · 09-03-2012, 10:22 AM

Quote:

Originally Posted by kaishang

You could just sub-contract it to a data centre in India

+1

Quote:

Originally Posted by MEGA

Any reason you felt the need to mention you were on a macbook pro?

I know what you mean here.
But I will take it from OPs' post that macbook pro is not as user friendly as windows

TheBingoBalls · 09-03-2012, 10:48 AM

Quote:

Originally Posted by makkan00

I know what you mean here.
But I will take it from OPs' post that macbook pro is not as user friendly as windows

It's still relevant to know that he was using a Mac. Whatever OP was trying to do, maybe he doesn't use the formula bar and you have to do it through menus, menus in Excel in Windows aren't the same in Excel for Mac.

Vaheed1 · 09-03-2012, 11:09 AM

Quote:

Originally Posted by MEGA

Any reason you felt the need to mention you were on a macbook pro?

Just incase the relevance of the machine mattered. As it happens, it didn't. I know there's allot of keystrokes/shortcuts that I can't do using the Macbook - actually, that was another question i wanted to ask. Does anyone know how I can switch between sheets using it? Normally, I can use the 'pgup' and pgdwn' keys on a 'normal' laptop/pc...no idea on the Mac.

rich1068 · 09-03-2012, 02:29 PM

It's a shame your original question was answered. I was going to call Mrs rich1068. She's an Excel Uber-Geek. She can make grown computers weep with her spreadsheets.

09-03-2012, 09:49 AM	#1
Vaheed1 Major 62 Rep 1,112 Posts Drives: E90 330d M Sport Join Date: Mar 2010 Location: Newcastle Upon Tyne iTrader: (0)	Any Excel nerds in here? Afternoon all. I'm wondering if anyone can advise me on this: I'm using MS Excel 2011 on a Macbook Pro. I have 52 sheets of data opened on the same workbook and would like to total data up from 1 particular box into a summary sheet at the end. Does anyone have any quick formula's that don't require me to go through every god damn sheet, manually adding them? Wouldn't be so bad if I had a separate mouse - but it's a complete ball ache on a tracker pad. I've googled it - but none of the suggestions help. Thanks.
	Appreciate 0 Tweet Quote

09-03-2012, 09:52 AM	#2
Vaheed1 Major 62 Rep 1,112 Posts Drives: E90 330d M Sport Join Date: Mar 2010 Location: Newcastle Upon Tyne iTrader: (0)	Don't worry chaps, I've worked it out. =SUM (<sheet number>:<sheet number>!<cell number>)
	Appreciate 0 Quote

09-03-2012, 10:01 AM	#3
Mani59 BMW Miniature Collector! 13479 Rep 7,986 Posts Drives: E38 735i SE Individual Join Date: Nov 2010 Location: Leicestershire iTrader: (1)	You could just amend the sheet number on the formula. Eg: =Sheet1!A1+Sheet2!A1 etc. EDIT: You got it
	Appreciate 0 Quote

09-03-2012, 10:06 AM	#4
kaishang Colonel 54 Rep 2,197 Posts Drives: 2010 E90 330d Join Date: Jul 2010 Location: London iTrader: (0)	You could just sub-contract it to a data centre in India
	Appreciate 0 Quote

09-03-2012, 10:17 AM	#5
MEGA Dieseasal 204 Rep 6,881 Posts Drives: LCI E92 335d M-Sport Join Date: Jan 2009 Location: Harrow, London iTrader: (2)	Any reason you felt the need to mention you were on a macbook pro? __________________ Previously: 2003 Peugeot 206 1.6 8v \| 2006 E90 320d M-Sport, 19" BBS CH, Full Ice-cold JL audio install, August 2010 Total BMW 6 page feature car. \| 2003 Nissan 350Z GT Coupe 286BHP Now:2010 E92 LCI 335d M-Sport
	Appreciate 0 Quote

09-03-2012, 02:29 PM	#9
rich1068 has left the building 90 Rep 3,359 Posts Drives: F30 330d M Sport Join Date: Oct 2010 Location: UK iTrader: (0)	It's a shame your original question was answered. I was going to call Mrs rich1068. She's an Excel Uber-Geek. She can make grown computers weep with her spreadsheets.
	Appreciate 0 Quote