- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel 2010 Question
Posted on 11/17/14 at 4:13 pm
Posted on 11/17/14 at 4:13 pm
I have multiple employees whose numbers I keep track of on individual sheets within one workbook. Is there a way to have a totals sheet where I can pull numbers from each sheet so when I update one person, it also updates the totals sheet?
This post was edited on 11/17/14 at 4:14 pm
Posted on 11/17/14 at 4:20 pm to 9Fiddy
Just use the SUM function and reference the specific sheet and cell you would like to combine with commas between each entry.
For example:
=SUM(Sheet1!A1,Sheet2!A1) located on Sheet 3 would total the numbers located on sheet 1, cell A1 and sheet 2, cell A1 in a cell located on Sheet 3.
For example:
=SUM(Sheet1!A1,Sheet2!A1) located on Sheet 3 would total the numbers located on sheet 1, cell A1 and sheet 2, cell A1 in a cell located on Sheet 3.
Posted on 11/17/14 at 4:22 pm to 9Fiddy
Using a formula?
What's dynamic in the other sheets?
What about a pivot table?
I'm not real clear on what you're trying to accomplish, but it sounds pretty easy and straightforward.
What's dynamic in the other sheets?
What about a pivot table?
I'm not real clear on what you're trying to accomplish, but it sounds pretty easy and straightforward.
Posted on 11/17/14 at 4:27 pm to PurpleGoldTiger
That's it. I knew it would be simple.
I was trying to avoid the pivot table as I have other people using this who will be able to click buttons and screw it up lol.
Thanks
I was trying to avoid the pivot table as I have other people using this who will be able to click buttons and screw it up lol.
Thanks
Posted on 11/17/14 at 4:29 pm to LSUtigerME
Popular
Back to top
Follow TigerDroppings for LSU Football News