- 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.
Related
October 2, 2025
AI-driven spreadsheet tools — what CPAs need to know
October 2, 2025
Car talk: M&A, AI and EVs changing the dealership landscape
October 2, 2025
Is spending on technology spinning out of control?
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