Create formulas rapidly

- [Instructor] In this worksheet…called HR List in our Chapter 7 file,…we want to create some statistics over in column L.…We've got headings in column M.…First of all, total compensation.…A lot of you know if we click column J…we're likely to see in the status bar…at the bottom of the screen what the total is.…If you're not seeing all these totals,…do a right-click on the status bar.…Consider checking all of these six entries right here,…or whichever ones you might need.…I usually keep them all checked.…So, that's at our fingertips.…We can see the total here, 54,468,000, and so on.…

Now, we might want to have this on…the screen up top, visible most of the time.…The numbers will be changing a lot.…We won't always want to be clicking that column.…Let's write a formula here.…I'm going to zoom in using control…on the mouse wheel to zoom in.…Many people, myself included in the past, will type =sum,…and there's certainly nothing wrong with this.…In fact, it's the correct way to get a total…if we want to add up the data in column J,…