AGGREGATE Function in Excel | How to Use AGGREGATE Function
In this video tutorial, you will learn the Microsoft Excel #AGGREGATE Function. This function is categorized under Math and Trig function in excel, before going to know about AGGREGATE you must be aware of the SUBTOTAL function that works similar to this function, but aggregate provides you many options that what to ignore or what to accept during the calculation, for example, if you want to do subtotal of a range where having the errors, aggregate can calculate the result without removing the error from the range that you selected.
Here I have explained the basic concept of this function.
Watch this video till the end to know more
Subscribe to YouTube & Follow on Facebook Page👇
/ exceluniverse
/ exceluniverse.in
Checkout Some Other Excel Tutorials Videos:
Subtotal Function👇
• SUBTOTAL Function in Excel | How to u...
Calculate Working Hours in Excel👇
• How to Calculate Working Hours in Excel
Excel MAX and MIN Functions👇
• MAX and MIN Function in Excel | Best ...
FILTERXML Function👇
• FILTERXML Function in Excel | Extract...
Download the practice file here👇
https://mega.nz/file/5rwxzCDC#1CqSqEe...