|
#1
|
|||
|
|||
With Grade in B2:B4 and Weight in C2:C4 try:
=SUMPRODUCT(B2:B4,C2:C4)/SUM(C2:C4) |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Complex IF(AND statement to manipulate weighted grades - better way? | ddeaton | Excel | 11 | 07-11-2016 02:03 PM |
Counting Grades on Excel Spreadsheet | Lear2016 | Excel | 1 | 01-04-2016 12:58 PM |
Powerpoint Quiz/Test advanced - Getting Grades or Results from Questions in show | Pete1 | PowerPoint | 1 | 05-17-2014 05:54 AM |
Equation help | markg2 | Excel | 11 | 02-05-2014 10:50 AM |
Why copying a paragraph to an equation ends without equation format??? | Jamal NUMAN | Word | 2 | 04-24-2011 06:18 AM |