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