1. news
  2. 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

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