9:41Use Array formulas to SUM IFERROR or use AGGREGATE, AVERAGE, TRANSFORM table and learn basicsRana Chowdhury2.2K views·9 years ago