E90Post
 


PYSPEED
 
BMW 3-Series (E90 E92) Forum > BMW E90/E92/E93 3-series General Forums > Regional Forums > UK > UK Off-Topic Discussions > Any Excel nerds in here?



Reply
 
Thread Tools Search this Thread
      09-03-2012, 09:49 AM   #1
Vaheed1
9
Captain
 
Drives: E90 330d M Sport
Join Date: Mar 2010
Location: Newcastle Upon Tyne

Posts: 983
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.
Vaheed1 is offline  
Appreciate 0
Reply With Quote
      09-03-2012, 09:52 AM   #2
Vaheed1
9
Captain
 
Drives: E90 330d M Sport
Join Date: Mar 2010
Location: Newcastle Upon Tyne

Posts: 983
iTrader: (0)

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

=SUM (<sheet number>:<sheet number>!<cell number>)
Vaheed1 is offline  
Appreciate 0
Reply With Quote
      09-03-2012, 10:01 AM   #3
Raj59
48
BMW Miniature Collector!
 
Raj59's Avatar
 
Drives: E60 LCI 525i M Sport Auto
Join Date: Nov 2010
Location: Leicestershire

Posts: 4,860
iTrader: (0)

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

=Sheet1!A1+Sheet2!A1 etc.

EDIT:

You got it
Raj59 is offline   United Kingdom
Appreciate 0
Reply With Quote
      09-03-2012, 10:06 AM   #4
kaishang
21
Colonel
 
Drives: 2010 E90 330d
Join Date: Jul 2010
Location: London

Posts: 2,198
iTrader: (0)

You could just sub-contract it to a data centre in India
kaishang is offline  
Appreciate 0
Reply With Quote
      09-03-2012, 10:17 AM   #5
MEGA
68
Dieseasal
 
MEGA's Avatar
 
Drives: LCI E92 335d M-Sport
Join Date: Jan 2009
Location: Harrow, London

Posts: 6,839
iTrader: (2)

Send a message via MSN to MEGA
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
MEGA is offline   United Kingdom
Appreciate 0
Reply With Quote
      09-03-2012, 10:22 AM   #6
makkan00
74
Major General
 
makkan00's Avatar
 
Drives: E91 330D
Join Date: Dec 2011
Location: Essex

Posts: 7,361
iTrader: (48)

Quote:
Originally Posted by kaishang View Post
You could just sub-contract it to a data centre in India
+1


Quote:
Originally Posted by MEGA View Post
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
__________________
makkan00 is online now   United Kingdom
Appreciate 0
Reply With Quote
      09-03-2012, 10:48 AM   #7
TheBingoBalls
17
Lieutenant Colonel
 
Drives: E90 325i, R56 MINI Cooper
Join Date: Mar 2011
Location: Toronto, Ontario

Posts: 1,771
iTrader: (1)

Quote:
Originally Posted by makkan00 View Post
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.
TheBingoBalls is offline   Canada
Appreciate 0
Reply With Quote
      09-03-2012, 11:09 AM   #8
Vaheed1
9
Captain
 
Drives: E90 330d M Sport
Join Date: Mar 2010
Location: Newcastle Upon Tyne

Posts: 983
iTrader: (0)

Quote:
Originally Posted by MEGA View Post
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.
Vaheed1 is offline  
Appreciate 0
Reply With Quote
      09-03-2012, 02:29 PM   #9
rich1068
33
has left the building
 
Drives: F30 330d M Sport
Join Date: Oct 2010
Location: UK

Posts: 3,363
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.
rich1068 is offline   United Kingdom
Appreciate 0
Reply With Quote
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 09:28 AM.




e90post
Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
1Addicts.com, BIMMERPOST.com, E90Post.com, F30Post.com, M3Post.com, ZPost.com, 5Post.com, 6Post.com, 7Post.com, XBimmers.com logo and trademark are properties of BIMMERPOST