Two Critical Excel Functions: VLOOKUP and SUMIFS

Description

The VLOOKUP function has long been the reigning champion of Excel's lookup functions. But the recently introduced SUMIFS function is quite powerful. So which function should we use to perform our lookup tasks? In this session, we'll dig into this question and see when and how these functions can be used. Course is presented in Excel for Windows. Note: Certain items presented may not be available in all Excel versions, including Excel for Mac, iPad or web. The webcast was originally broadcast on May 3, 2016. Note: There is a minimum passing rate of 70% for this course.

Highlights

• VLOOKUP function • SUMIFS function • VLOOKUP and SUMIFS comparison

Objectives

• Identify the differences between VLOOKUP and SUMIFS. • Recall the arguments for the VLOOKUP and SUMIFS functions. • Recognize the function that can return the sum of all matching values in a range.

Designed For

Accountants using Excel for Windows.