peterappiahkubi
New Member
- Joined
- Jun 12, 2021
- Messages
- 11
- Office Version
- 2013
- Platform
- Windows
| SUMMARY | ||||||
| S/N | NAME | TOTAL SCORE | AVERAGE | POSITION | POSITION | AGGREGATE |
| 1 | ACQUAH EMMANUEL | 615.0 | 68.3 | 1ST | #VALUE! | |
| 2 | AKUFFO DERRICK | 0.0 | 0.0 | 2ND | #VALUE! | |
| 3 | DON-GAGLA BENEDICT | 0.0 | 0.0 | 2ND | #VALUE! | |
| 4 | NYAME A. BLESSING | 0.0 | 0.0 | 2ND | #VALUE! | |
| 5 | SEKYERE JOSEPH | 0.0 | 0.0 | 2ND | #VALUE! | |
| 6 | YAHAYA ISSAH | 0.0 | 0.0 | 2ND | #VALUE! | |
| 7 | AIDOO AGNES | 0.0 | 0.0 | 2ND | #VALUE! | |
| 8 | ANTWI AMOANIMAAH LOIS | 0.0 | 0.0 | 2ND | #VALUE! | |
| 9 | ARHIN ELIZABETH | 0.0 | 0.0 | 2ND | #VALUE! | |
| 10 | BOAKYE BERNICE | 0.0 | 0.0 | 2ND | #VALUE! | |
| 11 | FORIWAA HAPPY OBENG | 0.0 | 0.0 | 2ND | #VALUE! | |
| 12 | FORSON LYDIA | 0.0 | 0.0 | 2ND | #VALUE! | |
| 13 | MANU OPARE KEZIAH | 0.0 | 0.0 | 2ND | #VALUE! | |
| 14 | SAMARI DORCAS | 0.0 | 0.0 | 2ND | #VALUE! | |
| 15 | TORKPO PRORCHIA EMEFA | 0.0 | 0.0 | 2ND | #VALUE! | |
| 16 | 0.0 | 0.0 | 2ND | #VALUE! | ||
| 17 | 0.0 | 0.0 | 2ND | #VALUE! |
I used this formular you provided me to add the grade for 4 compulsory subjects + 2 best other subjects out of the 9 subjects and it worked for me: =SUM(C2,D2,E2,F2,)+SMALL(G2:K2,1)+SMALL(G2:K2,2)
My problem now is that, I want to calculate their aggregate on the master sheet. I used this formular : =(ENGLISH!H3)+(MATHEMATICS!H3)+(SCIENCE!H3)+(SOCIAL!H3)+(SMALL(RME!H3:BDT!H3,1))+(SMALL(RME!H3:BDT!H3,2)) but had this as feedback in all the cells: #VALUE!
