If I have two types of values in columns B and C and corresponding to each pair of values, the average appears in column D. Is there a way to automate the averaging process?
You can use Excel's built in =AVERAGE function to average a range of values. By using it with other functions, you can extend its functionality.
Calculate the average of numbers
Goto cell where you want to print the average of B1:B60 and copy paste below line
=AVERAGE (B1 : B60)
and press enter .
1) Click on an empty cell. In the example, we chose cell F1 in which to enter our formula.
2) With your keyboard type the equal sign (=)
3) Begin the function by typing AVERAGE(
* Don't forget to open the parentheses!
4) Either type A1:E1 or use your mouse to highlight cells A1, B1, C1, D1 and E1
5) Complete the function with a closing parentheses by typing )
6) Press the key
the screenshot shows that you created a formula to calculate the average in the column D cell.
To automate the calculation for every subsequent row, you need to copy the formula to subsequent cells in the D column. The cell that is selected in your screenshot, do you see the little square in the bottom right? Click and hold it, while you drag it down, selecting the other cells. When you release it, the formula will be copied to these cells and it will be updated to it will calculate the average for (B5, C5) and (B6, C6) etc.
Thanks so much, Tina. Quick and dirty tip. I can't believe how simple it turned out to be!
Thanks again. :)
Glad it worked. :)