Tuesday Tip: Excel – The Fastest Way to See a Sum

by Richard Stokes

This week’s tip is a quick one because sometimes the easiest things are right in front of your nose.  If you work in spreadsheets a lot you probably need to view the sum of a range of numbers but may not necessarily need the formula to be a permanent resident on your spreadsheet.

Up until yesterday I would input the =SUM() formula in order to view a total.  No more – there’s a much better way to quickly see this:

In the illustrated spreadsheet, the Practice Administrator of XYZ Medical Group has asked me what the total cost is for just the workstations that they are about to buy as part of their network upgrade.  I quickly highlight the three cells associated with the desktop, laptop and tablet PC’s and at the bottom of the spreadsheet (red box in the associated image) it automatically calculates the average, count and sum in the status bar.

excel-sheet-for-blog-3-12-13.png

This tool works for both columns and rows and it also ignores any cells that you click that contain text or graphics instead of numbers.  Give it a try – I think my exact words were “Huh, I never knew that was there!”

Richard Stokes: As the Director of Sales for Network 1, Richard identifies “future” clients that can benefit from the support of an experienced, outsourced IT team. He helps clients and prospects find technology solutions they need to achieve better productivity and efficiency so they can focus their attention on making money and growing their respective business.

Network 1 designs, builds and supports the IT you need to run your business more securely, productively and successfully. Whether you want to outsource all of your IT needs to a reliable, responsive, service-oriented company, or need to supplement the work of your internal IT staff, we will carefully evaluate where you are now, discuss where you want to go and implement and support a plan to get you there with as little interruption as possible.

Leave a Comment





Related Posts