Supercharge Your Excel Sum Operations: Worksheets and Exhibits

BY J.D. KERN

July 1, 2009

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.

September 2, 2025

Incorporating prompt engineering into the accounting curriculum

September 1, 2025

Create a dynamic to-do list with Excel’s checkboxes

September 1, 2025

Another way to manage authentication texts

Technology

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

FROM THIS MONTH'S ISSUE

Flip out with the latest Tech Q&A

The September Technology Q&A column shows how to create dynamic to-do lists with Excel's checkboxes and also how to set up multifactor authentication texts that don't rely on phones. Flip through both items and view a video walkthrough in our digital format.

MAGAZINE

Supercharge Your Excel Sum Operations: Worksheets and Exhibits

Incorporating prompt engineering into the accounting curriculum

Create a dynamic to-do list with Excel’s checkboxes

Another way to manage authentication texts

Features

Calming nervous clients nearing retirement

7 retirement tips for small firm CPAs

Building a better CPA firm: Stepping up service offerings

2025 tax software survey

FROM THIS MONTH'S ISSUE

Flip out with the latest Tech Q&A

From The Tax Adviser

2025 tax software survey

Are you doing all you can to keep the cash method for your clients?

Current developments in S corporations

Paid student-athletes: Tax implications for universities and donors

MAGAZINE

HOME

ABOUT

SUBSCRIBE

AICPA & CIMA SITES