Thursday, February 5, 2015

Excel Tips & Tricks: ‘COUNT’ Functions and ‘SUM’ vs ‘SUBTOTAL’

Here are two Excel tips—one was raised by a team member in Managerial Reporting and thought that it was worth sharing; the other is common in Excel files where an alternative approach can make a file easier to understand and maintain.

1. The first topic involves a spreadsheet used to track meeting frequency and attendance, and which of the various COUNT functions is appropriate for the task.
2. The second topic is about the SUM and SUBTOTAL functions and when each is the most
appropriate.

All Tips and Tricks are archived on the blog.  We are also working with UHR to create a training class to bring all these topics together in a more structured class format – more information to come soon.

No comments: