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
FEATURE
Maximizing the higher education tax creditsA counterintuitive strategy can save taxes by including otherwise excludable scholarships in gross income.
SPONSORED REPORT
Solving the lease accounting challengeThe challenges of the new lease accounting standard have been pervasive to say the least. In this free, independently-written report, you'll learn effective adoption strategies as well as resources for easing the transition to the new standard.