AI · 1 min read

AGGREGATE

AGGREGATE function in Excel: Aggregate across a list or database.

Math function · Excel

AGGREGATE function

Aggregate across a list or database.

Availability

PlatformStatus
ExcelListed
Google SheetsNot listed
On Google Sheets: use SUBTOTAL. SUBTOTAL covers part of AGGREGATE. It does not ignore errors.
Reference entry. Syntax, tested examples and a practice file arrive with the full guide. Open the official function list.