Select cell C3 by clicking on it by your mouse. Functions are commands that require correct syntax in order to accomplish a specific task. Use AutoSum to quickly find the average AutoSum lets you find the average in a column or row of numbers where there are no blank cells.
The cells within the parenthesis are the start and end cells of your score sheet.
You can also enter the opening balance of the month if the system is considering it 0. SUM OFFSET L23COLUMNS L2L2-313 The COLUMNS function returns the number of columns in a range. The function uses the following arguments. To calculate AAGR in Excel.