How to SUM a List in Excel with Errors in Cells

#SUMinExcel #ExcelTricks #excelshorts

Simple SUM function cannot sum a list that includes errors. To SUM or add up a list that includes errors Aggregate function can be used.
Aggregate function helps to ignore errors from a list and sum the numbers.
Details are in video.