+ Reply to Thread
Results 1 to 4 of 4

Average of the sum of two columns

  1. #1
    Registered User
    Join Date
    08-29-2018
    Location
    Prague
    MS-Off Ver
    2016
    Posts
    2

    Question Average of the sum of two columns

    Hi there!
    Probably there is a very simple formula for this, but I'm quite new to spreadsheets :/

    Given the example in the picture, where C is the sum of A and B, is there a way I can get D1 without actually creating the column C?

    Thanks in advance!

    Screen Shot 2018-08-29 at 17.59.40.png

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Average of the sum of two columns

    How about:

    =Average(A1:B13)*2
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  3. #3
    Registered User
    Join Date
    08-29-2018
    Location
    Prague
    MS-Off Ver
    2016
    Posts
    2

    Re: Average of the sum of two columns

    Seems to do it!

  4. #4
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Average of the sum of two columns

    You wanted average of all the sums, which is same as adding all the numbers in columns A and B; then calculate average.
    Now you want to divide by half as many data points, which is same as dividing by total numbers of data points and multiplying by 2.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Average ifs with multiple columns as the average range
    By moneypennie21 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-15-2017, 08:14 AM
  2. average ifs with average range in different lines / columns
    By campelliann in forum Excel General
    Replies: 2
    Last Post: 12-23-2015, 07:49 AM
  3. [SOLVED] How to average certain Columns??
    By rmrjr22 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-01-2015, 12:37 PM
  4. average formula in excel with even columns only and columns with no value
    By DANNYH765 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-26-2014, 08:12 PM
  5. Average of different columns
    By TallOne in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-13-2013, 04:09 PM
  6. Average of last 3 columns
    By Joanne R. in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-03-2006, 05:25 PM
  7. Average of last 3 columns
    By CRIMP in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-18-2005, 03:01 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1