Editor's note: These are Web-exclusive exhibits for "Supercharge Your Excel Sum Operations."
Click here to download sample Excel worksheets. Each of the article's four exhibits is an individual worksheet in a single downloadable Excel file. It includes:
Exhibit 1: Sales by person using SUMIF
Exhibit 2: Basic functioning of SUMPRODUCT
Exhibit 3: Sales by person and month using SUMPRODUCT
Exhibit 4: TRUE-FALSE values as ones and zeros
SPONSORED REPORT
6 key areas of change for accountants and auditorsNew accounting standards on revenue recognition, leases, and credit losses present implementation challenges. This independently-written report identifies the hurdles that accounting professionals face and provides tips for overcoming the challenges.
PODCAST
How tax reform will impact individual taxpayersAmy Wang, a CPA who is a senior technical manager for tax advocacy at the AICPA, answers to some of the most common questions on how the new tax reform law will impact individual taxpayers.