Excel's Multiple Condition Summing Function (Currently Unavailable)

Author: Jeff Lenning

In this session, we'll discuss one of Excel's most important functions, the conditional summing function SUMIFS.

This function represents the cornerstore of formula-based reports, and is a critical Excel skill. Additionally, we'll briefly cover nested functions, how the idea of selection groups improves efficiency, and how to remove duplicate values from a list or table. Note: this course is designed for Microsoft Excel for Windows, and selected items may not be available in Excel for Mac.

Publication Date: June 2014

Designed For
Accounting professionals looking to learn more about Microsoft Excel for Windows.

Topics Covered

• Nested Functions
• Selection Groups
• Workbook Design Principles
• Selected Shortcuts
• Conditional Summing Basics with SUMIFS
• Remove Duplicates

Learning Objectives

• Identify a function that rounds a value to a specified number of digits
• Recall the arguments of the SUMIFS function
• Recognize the feature that removes duplicate values within a range

Level
Intermediate

Instructional Method
Self-Study

NASBA Field of Study
Computer Software & Applications (2 hours)

Program Prerequisites
Be familiar with tables, shortcuts, SUM, named references, data validation, conditional formatting, cell styles and SUBTOTAL

Advance Preparation
None