E90Post
 


Horizon LED
 
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
Captain
17
Rep
983
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
      09-03-2012, 09:52 AM   #2
Vaheed1
Captain
17
Rep
983
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
      09-03-2012, 10:01 AM   #3
Raj59
BMW Miniature Collector!
Raj59's Avatar
United Kingdom
53
Rep
4,888
Posts

 
Drives: E90 M3 LCI
Join Date: Nov 2010
Location: Leicestershire

iTrader: (0)

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

=Sheet1!A1+Sheet2!A1 etc.

EDIT:

You got it
Appreciate 0
      09-03-2012, 10:06 AM   #4
kaishang
Colonel
25
Rep
2,198
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
      09-03-2012, 10:17 AM   #5
MEGA
Dieseasal
MEGA's Avatar
United Kingdom
108
Rep
6,849
Posts

 
Drives: LCI E92 335d M-Sport
Join Date: Jan 2009
Location: Harrow, London

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
Appreciate 0
      09-03-2012, 10:22 AM   #6
makkan00
Major General
makkan00's Avatar
United Kingdom
126
Rep
7,593
Posts

 
Drives: F10
Join Date: Dec 2011
Location: Essex

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
__________________
Appreciate 0
      09-03-2012, 10:48 AM   #7
TheBingoBalls
Lieutenant Colonel
Canada
19
Rep
1,815
Posts

 
Drives: E90 325i, R56 MINI Cooper
Join Date: Mar 2011
Location: Toronto, Ontario

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.
Appreciate 0
      09-03-2012, 11:09 AM   #8
Vaheed1
Captain
17
Rep
983
Posts

 
Drives: E90 330d M Sport
Join Date: Mar 2010
Location: Newcastle Upon Tyne

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.
Appreciate 0
      09-03-2012, 02:29 PM   #9
rich1068
has left the building
United Kingdom
54
Rep
3,363
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
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 04:59 PM.




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