MGSLG ICTCFT. (2017). Averaging column values (CC BY-SA)

Video Transcript

    1. To find out the average for the first test, select the cell directly under the column sum. This is where the answer will appear. In this example it would be C16 but you need to check your own workbook.
    2. In this cell type the following formula: =AVERAGE(C4:C14). What you have asked for is to use the average function to determine the average value in column C from row 4 to row 14. You might again need to change the last row address to suit your particular workbook.
    3. Type ‘Average’ on the same row but in Column A and make both label and values bold.
    4. Your mark book should look similar to the one below:



Last modified: Tuesday, 3 November 2020, 3:31 PM