Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Finding an average

  1. #1
    New Member
    Join Date
    May 2006
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Finding an average

    ColA ColB
    4 1
    3 2
    2 3
    5 3
    2 3
    1 2

    A20 B20
    17 14

    Sum ColA and Multiply by 3 (17*3) = 51
    Sum ColB and Multiply by 2 (14*2) = 28

    Then I need to add those 2 values (51+28) and then divide by the SUM of combined columns (79/31)

    I have =(A20*3) + (B20*2) …. But how do I add the DIVIDE by the SUM of A20+B20????
    Last edited by ram6402; Jan 11th, 2019 at 02:10 PM.

  2. #2
    Board Regular rpaulson's Avatar
    Join Date
    Oct 2007
    Location
    Fremont, OH USA
    Posts
    1,005
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Finding an average

    =(a20*3 + b20*2) / (a20 + b20)
    Last edited by rpaulson; Jan 11th, 2019 at 02:18 PM.

  3. #3
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    47,628
    Post Thanks / Like
    Mentioned
    39 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Finding an average

    Try:
    Code:
    =((A20*3) + (B20*2))/(A20+B20)
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  4. #4
    New Member
    Join Date
    May 2006
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Finding an average

    Thank you guys SO much!!!! =((A20*3) + (B20*2))/(A20+B20) was the winner!!!!

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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