Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-03-2018, 01:50 AM
xor xor is offline Equation for weighting on grades? Windows 10 Equation for weighting on grades? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

With Grade in B2:B4 and Weight in C2:C4 try:

=SUMPRODUCT(B2:B4,C2:C4)/SUM(C2:C4)
Reply With Quote
Reply



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
Equation for weighting on grades? Counting Grades on Excel Spreadsheet Lear2016 Excel 1 01-04-2016 12:58 PM
Equation for weighting on grades? Powerpoint Quiz/Test advanced - Getting Grades or Results from Questions in show Pete1 PowerPoint 1 05-17-2014 05:54 AM
Equation for weighting on grades? Equation help markg2 Excel 11 02-05-2014 10:50 AM
Equation for weighting on grades? Why copying a paragraph to an equation ends without equation format??? Jamal NUMAN Word 2 04-24-2011 06:18 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft