Availability
| Platform | Status |
|---|---|
| Excel | Listed |
| Google Sheets | Not 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.