Results 1 to 8 of 8

Calculate weighted averages using high, medium, low

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-17-2004
    MS-Off Ver
    Office 2016
    Posts
    527

    Calculate weighted averages using high, medium, low

    On another thread I found a solution to creating a weighted average given a pair of columns of numbers but I have column B consisting of values given as High, Medium and Low and the weighted column C of 1, 2 or 3.

    How can I use the formula below to accomplish this, or is this maybe not the right way to created a weighted average?

    =SUMPRODUCT(B2:B11,C2:C11)
    Last edited by JimDandy; 01-05-2009 at 03:20 PM.

Thread Information

Users Browsing this Thread

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

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