+ Reply to Thread
Results 1 to 2 of 2

Weighted Average Function for Series Weighted by Increments of 1

  1. #1
    Registered User
    Join Date
    10-05-2018
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    1

    Weighted Average Function for Series Weighted by Increments of 1

    Excel amateur here..

    Is there a way to calculate a weighted average for a series of numbers where each value in the series is increasingly weighted by a value of 1? An example would be:

    =(A1+(A2*2)+(A3*3))/1+2+3

    ...however, I would like it to be in the form of a saved function so that it becomes dynamic enough to apply the logic to any series of numbers of varying length and cell positions. I also want the series of weights (i.e., 1, 2, 3...) to be inherent, without having to create a second array for weights every time this calculation is needed.

    Thanks.

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    2013, Office 365 ProPlus
    Posts
    4,965

    Re: Weighted Average Function for Series Weighted by Increments of 1

    Something like below.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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