Catagory averages are effecting each other , What to do?
Posted by Charles on January 18, 2002 4:31 PM
I am using this formula.
=SUM(IF((C$28:V$28="WEX 121")*(C32:V32),C32:V32))/MAX(1,COUNTIF(C32:V32,">0"))
I have several single grades that are averaged into various catagory grades that are then averaged into a final grade.
The above formula is alowing my catagory grades to effect each other.
If I have a score of 100 in a single catagory called WEX everything is OK, but when a second catagory WEL gets an average of 50 they effect each other. WEX drops to 50 and WEL shows up as 25. Does anyone know how I can fix this?