AGGREGATE with SUBTOTAL Function in Advance Excel in Hindi @apnadigitaladvancecomputeretah

The AGGREGATE function in Excel allows you to perform different types of calculations (like SUM, AVERAGE, MAX, MIN, etc.) while optionally ignoring errors, hidden rows, or other filtered data. It is especially useful in scenarios where regular functions might fail due to errors or hidden data.

Syntax: AGGREGATE(function_num, options, array, [k])

function_num: A number (1 to 19) representing the function to perform (e.g., 1 for AVERAGE, 9 for SUM, etc.).
options: A number (0 to 7) determining what to ignore (hidden rows, errors, etc.).
array: The range of data to perform the calculation on.
k: (Optional) Required for certain functions like LARGE, SMALL, PERCENTILE.

✆ 7500715902, 8868831763
✉ ramkishor3etah@gmail.com

https://youtu.be/nqAlAOuL6Kk?si=airfxRAC2t5T5bf4

#excel #advancexcel #aggregate #aggregatefunction #excelgyan #excelformula #exceltutorial

Видео AGGREGATE with SUBTOTAL Function in Advance Excel in Hindi @apnadigitaladvancecomputeretah канала KNOWLEDGE JUNCTION MAP 1991