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 it by 2.…Well, maybe that would work in this case,…