The AGGREGATE function in Excel is a versatile feature designed to perform calculations like sums, averages and counts while selectively ignoring elements such as hidden rows, errors, or filtered-out ...