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

Where to find July’s flipbook issue

The Journal of Accountancy is now completely digital. 

 

 

 

SPONSORED REPORT

Better decision-making with data analytics

Data analytics has become a hot topic, but many organizations have not yet managed to understand its potential, let alone put it to work. This report will take a deep-dive on how to best introduce or enhance the use of data in decision-making.