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.
Get my free accounting and auditing digest with the latest content.
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.
Please log in again. The login page will open in a new tab. After logging in you can close it and return to this page.