Two Critical Excel Functions: VLOOKUP and SUMIFS

Overview

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

Designed For

Accountants using Excel for Windows.

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.

Notice

This is a self-study/on demand course offered by a 3rd party vendor and will NOT be accessible in the My Upcoming CPE section of the ISCPA website. Course access information will be emailed directly to you by CalCPA. The course expires one year from the purchase date. Format = Online Self-Study.