- news
- TECHNOLOGY WORKSHOP
Supercharge Your Excel Sum Operations: Worksheets and Exhibits
BY J.D. KERN
Please note: This item is from our archives and was published in 2009. It is provided for historical reference. The content may be out of date and links may no longer function.
Add us on Google
➕
Click here to add us as a preferred news source on Google.
Related
November 19, 2026
Tax practitioners need updated AI guidance, council tells IRS
November 10, 2026
What Binance’s $6.3B crypto hack means for CPAs
November 1, 2026
Why AI needs to show its work
TOPICS
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
