+ Reply to Thread
Results 1 to 2 of 2

Weighted Average Help

  1. #1
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2010
    Posts
    100

    Weighted Average Help

    In Column F on the attached, I want to get the weighted average of the difference between column D and column E. For example, F4 shows a 3.55% increase YOY. What's the overall weighted average?

    Thanks.
    Attached Files Attached Files

  2. #2
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,941

    Re: Weighted Average Help

    =(sum(e4:e20)-sum(d4:d20))/sum(d4:d20)
    try this
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

+ 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. Weighted Average
    By Bob@Sun in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-28-2010, 08:49 AM
  2. Weighted Average
    By Brandy in forum Excel General
    Replies: 2
    Last Post: 12-01-2008, 10:34 AM
  3. weighted average
    By inoexcel in forum Excel General
    Replies: 3
    Last Post: 05-01-2006, 05:10 PM
  4. Non zero weighted average
    By jeffsfas in forum Excel Formulas & Functions
    Replies: 60
    Last Post: 09-06-2005, 10:05 AM
  5. [SOLVED] What is this kind of average called?-weighted average
    By havocdragon in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-24-2005, 01:05 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