From the course: Excel 2016: Advanced Formulas and Functions
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Preventing double counting
From the course: Excel 2016: Advanced Formulas and Functions
Preventing double counting
- On this worksheet called Subtotal, you'll see over in Columns A thru E, we've got lists, first for people in Accounting Management, and the in Facilities Engineering, and so on. We'd like to put in some totals here, for a report, right here. I'm simply going to use AutoSum, Alt=, there it is. To make this a little faster for each of these, I'll click the cell, and now using the Ctrl key, click the next one, and scrolling down a bit, using the Ctrl key, clicking here and here, we want totals of in all these cases. I'll simply press Alt=, and we'll have totals on all these. That's great. Now, off to the right here, I'd like to see a total of the entire list, so I'll just use AutoSum again, Alt=, a good fast way to get started with it. Press Column E, and I've worked with the numbers in the past and I know that's just way too large. You, of course, would know what's happening here. What's happening? We're actually getting a double count here. You can make a case by saying, just divide…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.