How do you use the aggregate function in Excel?

Answer 1

An aggregate function allows you to use different operations on a range of cells in Excel even though that range of cells may contain errors. This aggregate function uses the sum function on the range of cells A2 to A7 with errors, but it will still calculate the total because you are using the Aggregate function.

Answer 2

An aggregate function allows the user to use different functions on a range of cells that may or may not contain errors.

Below shows an aggregate function using the sum function and ignoring the errors. It adds only the values in the range of cells:

The 9 represents SUM function

6 means to ignore the errors and

C1:C6 is the range of cells to add is stated.