|
|
|
|
|
|
BMW Garage | BMW Meets | Register | Today's Posts | Search |
|
BMW 3-Series (E90 E92) Forum
>
Any Excel nerds in here?
|
|
09-03-2012, 09:49 AM | #1 |
Major
64
Rep 1,112
Posts |
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. |
09-03-2012, 10:17 AM | #5 |
Dieseasal
208
Rep 6,881
Posts |
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 |
Major General
896
Rep 9,103
Posts |
+1
I know what you mean here. But I will take it from OPs' post that macbook pro is not as user friendly as windows
__________________
F36 Xdrive for her - HUD, park assist, heated steering wheel, rear camera, Apple car play
F36 RWD for him - HK, M sports pack, GTS tail light, Apple car play |
Appreciate
0
|
09-03-2012, 10:48 AM | #7 |
Brigadier General
4231
Rep 4,833
Posts
Drives: BMW
Join Date: Mar 2011
Location: Toronto, Ontario
|
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 |
Major
64
Rep 1,112
Posts |
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 |
has left the building
91
Rep 3,359
Posts |
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
|
Bookmarks |
|
|