Excel's AGGREGATE function works with vertical ranges only, not horizontal ranges. So, when you reference a horizontal range, AGGREGATE will not ignore rows in hidden columns.

Learn Excel 365 calculated columns to enhance your data analysis skills with dynamic formulas, cross-table calculations for real-time insight ...

Some of the most common aggregate functions in Excel are SUM, AVERAGE, MIN, MAX, and COUNT. These functions can take one or more arguments, such as a range of cells or a criteria.

Aggregate functions form the foundation of financial modeling in Excel. These functions allow you to efficiently summarize and analyze large datasets, allowing you to extract meaningful insights ...

Product Function Excel provides the PRODUCT () function to calculate the original value by the percentage markup. Place your original value or cost into column A and label it with a description.