Questing Vole Press
Mastering Excel Sum and Count Formulas

Mastering Excel Sum & Count Formulas
Excel 2016 Update
by Tim Hill

Download this book’s companion files.


Summing and counting values are the most common spreadsheet operations, and Excel’s capabilities go far beyond routine SUM and COUNT formulas. Author Tim Hill shows you how to use worksheet functions, array formulas, AutoSum, and other Excel features to summarize an entire range of values, or only values that meet specific conditions. If you’re using an older version of Excel that doesn’t support the latest worksheet functions, you’ll find equivalent formulas that work in Excel 2003 or earlier. You can download the sample workbook to follow along with the author’s examples.


1. Getting Started with Sums & Counts
2. Counting Basics
3. Counting Tricks
4. Frequency Distributions
5. Summing Basics
6. Summing Tricks


Amazon preview.

Download (sample workbook).

Prices and formats

   Amazon Kindle (US, CA, UK, AU, FR, DE, NL, ES, IT, JP, BR, IN, MX)
   Apple iBooks (US, CA, MX, AU, NZ, UK, IE, DE, IT, SE, NL, DK, JP)
   Barnes & Noble Nook
   Google Play