The AGGREGATE function has two syntaxes—one for references and one for arrays—though you don't need to get yourself tied up in knots over which one you're using, as Excel selects the relevant ...

SUM tells Excel you want the total columns to add the figures together. On the other hand, if, for example, you use AVERAGE, the result will show you the mean of those figures instead.