Excel

  AGGREGATE FUNCTION WEBSITE The aggregate function is an Excel function with multiple functions within it. What if the data is filtered and also has errors like N/A or DIV/0? Well, as shown below, the user can ignore both hidden rows and errors. The sum would have been a 100 of the full data, but when filtered it is actually 70 by using the aggregate function. The count would have been 4, but when filtered it is actually 3 if we are excluding the error by using the aggregate function.

AGGREGATE FUNCTION WEBSITE The aggregate function is an Excel function with multiple functions within it. One example is below where user can sum up values even if there is a "N/A" or "DIV/0" error.