How can I automate a calculation of two columns in a third column in Excel?

Sudeep June 10, 2011
Pinterest Stumbleupon Whatsapp

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?

Screenshot:

Ads by Google

  1. Anonymous
    June 10, 2011 at 3:50 pm

    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.

    http://www.cpearson.com/excel/excelf.htm

    Calculate the average of numbers
    http://office.microsoft.com/en-us/excel-help/calculate-the-average-of-numbers-HP003056135.aspx

    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

    http://phoenix.phys.clemson.edu/tutorials/excel/arithmetic.html

    • The Creativ3 Bee
      June 12, 2011 at 11:40 am

      Thanks, ha14!

  2. Tina
    June 10, 2011 at 3:36 pm

    Sudeep,

    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.

    • The Creativ3 Bee
      June 12, 2011 at 11:35 am

      Thanks so much, Tina. Quick and dirty tip. I can't believe how simple it turned out to be!
      Thanks again. :)

      • Tina
        June 13, 2011 at 6:26 pm

        Glad it worked. :)