AGGREGATE
Math & trigExcel 2010Like SUBTOTAL but can also ignore error cells and do LARGE/SMALL/PERCENTILE.
Syntax
AGGREGATE(function_num, options, ref1, [ref2] | array, [k])
Examples
=AGGREGATE(9, 6, C2:C500)
→ SUM ignoring errors
Related functions
More Math & trig functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.