Supercharge Your Excel Sum Operations: Worksheets and Exhibits

BY J.D. KERN

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

CPEOs provide peace of mind around payroll services

The creation of these new IRS-certified service providers for small businesses clarifies some issues around traditional professional employer organizations.

QUIZ

Pronoun practice to help polish your prose

Using pronouns correctly in writing and speech can help you make a good impression. Try our 10-question quiz.