On the Table Tools Layout tab click the Formula button. COUNT Calculates the number of elements identified inside the parentheses. Click in a cell that contains formula output.
Formula AVERAGEIF range criteria average_range The AVERAGEIF function uses the following arguments.
Click in a cell that should contain the sum of the rows. Under Formula Word takes a guess as to the formula you might want to use and displays SUM LEFT. For example the AVERAGE function below calculates the average of the numbers in cells A1 through A3. Step 1 Consider the following table with the total number of rows.