Skip navigation

Using the AGGREGATE function to bypass errors and hidden rows

Using the AGGREGATE function to bypass errors and hidden rows: Excel 2016: Managing and Analyzing Data
Using the AGGREGATE function to bypass errors and hidden rows: Excel 2016: Managing and Analyzing Data

The AGGREGATE function gives you tabulation options, including SUM, AVERAGE, and 17 other functions, automatically displayed as you type the function. Other options let you ignore cells in a range that contain errors, are part of a hidden row, or those that contain AGGREGATE and SUBTOTAL functions.

Resume Transcript Auto-Scroll
Skill Level Intermediate
3h
Duration
172,253
Views
Show More Show Less

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start Your Free Trial Now

Start your free trial now, and begin learning software, business and creative skills—anytime, anywhere—with video instruction from recognized industry experts.

Start Your Free Trial Now