SI. Formula Description Example Usage 1 SUM Adds a range of numbers 36 2 AVERAGE Calculates the average of a range #DIV/0! 3 COUNT Counts the number of cells with numbers 0 4 COUNTA Counts non-empty cells 9 5 IF Checks a condit…