+ 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
    Office 365 ProPlus
    Posts
    5,556

    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)

Similar Threads

  1. Replies: 0
    Last Post: 02-15-2018, 03:04 AM
  2. [SOLVED] Weighted Average of Sequential Time Based Data Series Using Start/End Time Input
    By marcoyul in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-16-2017, 12:10 PM
  3. Custom weighted average function for 3d ranges
    By Atom in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-18-2015, 06:15 PM
  4. sumproduct function for weighted average
    By copperdog in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-18-2014, 10:18 PM
  5. Constant Weighted Average with IF Function.
    By rylock in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-17-2008, 04:12 AM
  6. [SOLVED] Weighted Average - Copy Function
    By Melissa in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-06-2006, 01:55 PM
  7. Weighted Average function
    By shekala in forum Excel General
    Replies: 3
    Last Post: 12-10-2005, 07:35 AM

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