Calculate the total number. Find the sum of the numbers. AVERAGE C3E3 At each new row AVERAGE calculates an average of the quiz scores for each person.
Here we discuss the list of top 10 Basic Formulas Functions in Excel including SUM COUNT COUNTA COUNTBLANK MAX MIN etc.
The formula in F3 copied down is. We can use any basic operation here such as Sum Average Percentile Vlookup Mean Etc. Let x 1 x 2 x 3 x n be a set of numbers average x 1 x 2 x 3 x n n. A typical way to use the AVERAGE function is to provide a range as seen below.