Excel AGGREGATE Function (Multiple Criteria with Examples)

Excel AGGREGATE function (multiple criteria with examples). In this video, learn how to use AGGREGATE function numbers and options (1 to 19 numbers and 0 to 7 options) to create a result that can exclude hidden rows, ignoring error values, ignoring nothing and nested SUBTOTAL. You will also learn the benefits of using the Aggregate function over the Subtotal function in excel.

In this Excel Aggregate Function Tutorial, you will learn:

1. How to use aggregate function in excel
2. How to use excel aggregate function with multiple criteria or conditions
3. How to use excel aggregate function numbers (1 to 19)
4. How to use excel aggregate function options (0 to 7)
5. How to use excel aggregate function by ignoring nested SUBTOTAL
6. How to use excel aggregate function by ignoring hidden rows
7. How to use excel aggregate function by ignoring error values
8. How to use excel aggregate function by ignoring nothing
9. How to use excel aggregate function by ignoring hidden rows and error values
10. How to use excel aggregate function by ignoring hidden rows, error values and nested SUBTOTAL
11. The aggregate function examples for easy understanding

Learn how to use the Aggregate function's 01 to 19 calculations and 0 to 7 options to create a result that can include or exclude hidden rows, filtered rows, cell errors and nested SUBTOTAL. The AGGREGATE function can apply different aggregate functions to a list of data with the option to ignore hidden rows and error values.

★★ NEW Functions in Excel ★★

https://excel2019.com/new-functions/
https://www.youtube.com/watch?v=Je7yTWx4z24&list=PLxjABGKb4DEi7boBibihO9YjYPXdgAumH&index=1&t=200s

★★ SUBTOTAL Functions in Excel ★★

https://www.youtube.com/watch?v=70B7cm-WYog&list=PLxjABGKb4DEi7boBibihO9YjYPXdgAumH&index=5&t=118s

★★ TOP 10 Functions in Excel ★★

https://www.youtube.com/watch?v=l1DI6WxyQRI&list=PLxjABGKb4DEi7boBibihO9YjYPXdgAumH&index=3

EXCEL AGGREGATE FUNCTION

SYNTAX:
=AGGREGATE(function_num, options, ref1, [ref2], …)
= AGGREGATE(function_num, options, array, [k])

FUNCTION_NUM:
The function number 1 to 19 can be used as shown below:

1 – AVERAGE
2 – COUNT
3 – COUNTA
4 – MAX
5 – MIN
6 – PRODUCT
7 - STDEV.S
8 - STDEV.P
9 – SUM
10 - VAR.S
11 - VAR.P
12 - MEDIAN
13 - MODE.SNGL
14 - LARGE
15 - SMALL
16 - PERCENTILE.INC
17 - QUARTILE.INC
18 - PERCENTILE.EXC
19 - QUARTILE.EXC

OPTIONS:
The options from 0 to 7 can be used as shown below:

0 or omitted - ignore nested SUBTOTAL and AGGREGATE functions
1 - ignore hidden rows, nested SUBTOTAL and AGGREGATE functions
2 - ignore error values, nested SUBTOTAL and AGGREGATE functions
3 - ignore hidden rows, error values, nested SUBTOTAL and AGGREGATE functions
4 - ignore nothing
5 - ignore hidden rows
6 - ignore error values
7 - ignore hidden rows and error values

EXCEL AGGREGATE FUNCTION (Timer)

Skip to 00:00 introduction

Skip to 00:28 aggregate function

Skip to 01:00 ignore nothing

Skip to 01:20 ignore hidden row

Skip to 02:03 ignore hidden row & error

Skip to 02:42 SUBTOTAL

Skip to 03:05 nested SUBTOTAL

Excel aggregate function (multiple criteria) examples - video tutorial. Excel aggregate function (multiple criteria) with examples in excel 2019, excel 2016, excel 2013, excel 2010, excel 2007 and excel office 365 (same in all versions). The aggregate function in excel can be used to apply 19 function numbers with 7 options in a list of data, with ignore nothing, ignore hidden rows, error values and nested subtotal.

Use aggregate function in excel, excel aggregate function with multiple criteria or conditions, excel aggregate function numbers (1 to 19), excel aggregate function options (0 to 7), excel aggregate function examples.

★★ Learn More ★★

SORT Function: https://www.youtube.com/watch?v=nL7Crq0AC0w

FILTER Function: https://www.youtube.com/watch?v=B0Pkk2MwXsU

IF Function: https://www.youtube.com/watch?v=sSimNETBVAQ&list=PLxjABGKb4DEi7boBibihO9YjYPXdgAumH&index=5

SUMIFS Function: https://www.youtube.com/watch?v=0crRRIsq4OI&list=PLxjABGKb4DEi7boBibihO9YjYPXdgAumH&index=4

LET Function NEW: https://www.youtube.com/watch?v=ENvkkieNz8c&list=PLxjABGKb4DEi7boBibihO9YjYPXdgAumH&index=6

★★ CONNECT with US ★★

Subscribe Gopal Kr Rath YouTube Channel:
https://www.youtube.com/GopalKrRath/?sub_confirmation=1

Facebook: https://www.facebook.com/GopalKrRath

Instagram: https://www.instagram.com/GopalKrRath

Twitter: https://twitter.com/GopalKrRath

SUBSCRIBE: Please subscribe to our channel for more useful videos.

LIKE: If you like the video then please hit the like button.

SHARE: Feel free to share with your friends and family in social networks to improve their knowledge.

COMMENT: Your comment will motivate us to add more and more videos and will resolve your queries.

Thanks for watching MS Office Tutorial by
Gopal Krishna Rath @RathPoint

#excelaggregatefunction #aggregatefunctioninexcel #aggregatefunction #excelaggregatefunctionmultiplecriteria #excelaggregatefunctionexample