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!
Bookmarks