+ Reply to Thread
Results 1 to 2 of 2

SOLVED - Averaging weighted scores without counting blanks

  1. #1
    Registered User
    Join Date
    01-20-2020
    Location
    Troy, MO
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    2

    SOLVED - Averaging weighted scores without counting blanks

    I've reviewed the forum and ran across the solution posted back a few years ago in the forum under 866645-average-weighted-grades-with-blank-cells.html#post3081477. It was right up my alley but its not quite doing what I want. ((apologies, I'm new and I can't post the full url to the post I'm referencing))

    I am trying to calculate an overall score for a scorecard of four sections. Each section is worth various points and I want to emphasize one or two areas over the others, so I've weighted them to have a bit more of an impact. When applying the formula which was givein in the example above, it appears the average I'm getting in D39 is still taking the black cell (D38) in the attached spreadsheet into account. There will be times where some sections might not be graded and, as such, they should not have an affect on the overall score. If I only score two sections, I want the final score to represent only those two sections (to include the weight).

    Using =SUMPRODUCT(D35:D38,C35:C38)/SUMIF(D35:D38,"<>",C35:C38) in the uploaded spreadsheet, three 100%, should score 100%, not 83.33%. Or at least, that's what I'm asking to achieve. I'm sure it's an easy tweak that I'm just overlooking but at this point my brain is done.

    Thank you in advance!
    Attached Files Attached Files
    Last edited by BamaRatt; 01-20-2020 at 02:07 PM. Reason: Solved the problem

  2. #2
    Registered User
    Join Date
    01-20-2020
    Location
    Troy, MO
    MS-Off Ver
    Office 365 Pro Plus
    Posts
    2

    Re: Averaging weighted scores without counting blanks

    SOLVED! The text values in the grade cells are what are breaking the formula. Found, fixed, and solved!

+ 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: 1
    Last Post: 02-28-2018, 02:38 AM
  2. [SOLVED] Ignore blanks for weighted grades
    By MSExcelLnr in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-24-2017, 06:44 PM
  3. Replies: 4
    Last Post: 07-20-2016, 01:08 PM
  4. Weighted Scores
    By Ericen in forum Excel General
    Replies: 2
    Last Post: 01-02-2015, 12:18 PM
  5. Weighted Average without blanks
    By zvot in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-06-2014, 12:28 PM
  6. Averaging different scores by account
    By ianco in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-26-2011, 06:05 PM
  7. [SOLVED] Averaging Golf Scores
    By Jerry in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-16-2006, 12:50 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