The Excel's AGGREGATE function is a built-in function in Excel that is classified as a Math/Trig Function. AGGREGATE function enables you to perform calculations such as AVERAGE, SUM, COUNT, MAX or MIN and ignore errors or hidden rows. There are two forms for the AGGREGATE function:
Reference form:
=AGGREGATE(function_num, options, ref1, ref2, ref[3],…)
Array form:
=AGGREGATE(function_num,options,array,[k])
🙏 Follow us on our Facebook page
🙏 Join our facebook group to get more depth in learning of different technologies
🙏 Subscribe To Our Channel
🙏 For Suggestions and Help, direct message us on Facebook Messenger
m.me/powerofknowledgein
#excel
0 Comments