This table lists the numbers you can input to exclude certain values when creating your AGGREGATE formula (argument b):. Now, let's look at some examples of how you can use the AGGREGATE function ...

In the screenshot below, the same data has been summed three ways using the SUM, SUBTOTAL and AGGREGATE functions in cells A7, B7 and C7, respectively. (The formulas in row 7 are spelled out on row 8 ...