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
Get your clients ready for tax seasonUpon its enactment in March, the American Rescue Plan Act (ARPA) introduced many new tax changes, some of which retroactively affected 2020 returns. Making the right moves now can help you mitigate any surprises heading into 2022.
100th ANNIVERSARY
Black CPA Centennial, 1921–2021With 2021 marking the 100th anniversary of the first Black licensed CPA in the United States, a yearlong campaign kicked off to recognize the nation’s Black CPAs and encourage greater progress in diversity, inclusion, and equity in the CPA profession.