| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
% error calculating grades
I am using the formula below to calculate the % of males (denoted as "M" in the F column) scoring A*, A, B,.... U (contained in the H column) in a list: =SUMPRODUCT(--($F$48:$F$432="M"),--($H$48:$H$432="A*"))/ COUNTIF($F$48:$F$432,"?*") In my test I find that if I have 4 entries - 3 male & 1 female it will report that 25% of males scored A*, 25% scored A and 25% scored B, instead of 33.3% for 3 boys only. It is including the female score when doing the % calculation. How can I isolate the boys only scores ? -- Marie1uk ------------------------------------------------------------------------ Marie1uk's Profile: http://www.excelforum.com/member.php...o&userid=20984 View this thread: http://www.excelforum.com/showthread...hreadid=384082 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Do any of the Grade book templates using Excel average grades? | Excel Discussion (Misc queries) | |||
| Vlookup student grades | Excel Discussion (Misc queries) | |||
| Converting Letter Grades to Numeric | Excel Worksheet Functions | |||
| grades | Excel Discussion (Misc queries) | |||
| How do calculate grades in Excel? | Excel Worksheet Functions | |||
Threaded Mode
