Excel: The Sum of Selected Cells Saves Time

By Charles Hall | Technology

Dec 26

Are you using Excel’s sum of selected cells feature? You should be.

CPAs love their ten-keys.

But a roll of adding machine tape on the floor does not mean I’m efficient. The sum of selected cells feature in Excel saves time and increases accuracy. Here’s how.

 

Now, isn’t that better than using a ten-key? Notice also that Excel provides you with a count, the number of items in the selected cells. Additionally, you can see the average as well. All at the bottom right-hand corner of your spreadsheet. 

Learn from my CPA Hall Talk newsletter!

Get my free accounting and auditing digest with the latest content.

Powered by ConvertKit
Follow

About the Author

Charles Hall is a practicing CPA and Certified Fraud Examiner. For the last thirty years, he has primarily audited governments, nonprofits, and small businesses. He is the author of The Little Book of Local Government Fraud Prevention and Preparation of Financial Statements & Compilation Engagements. He frequently speaks at continuing education events. Charles is the quality control partner for McNair, McLemore, Middlebrooks & Co. where he provides daily audit and accounting assistance to over 65 CPAs. In addition, he consults with other CPA firms, assisting them with auditing and accounting issues.

>
0 Shares
Tweet
Share
Share
Flip
Email