Hello all,
Please I need your assistance on how to copy datas or scores from one sheet to another by using Formulas & Functions.
I tried to attached excel file as an example, but it couldnt.
Let me explain briefly:
The file contains 11 Sheets, the first 4 Sheets has students Continous Assessment of various subjects (about 7 subjects) in 4 different classess.
What I want is, the formulas or functions to use on how to copy the total score in all subjects for each student in various classess (Primary 1A, Pri 1B, Pri 1C, Pri 1D) to Sheets (1st Term, 2nd Term, 3rd Term) as class summary.
And thirdly, the total scores, position, grade & average to also appear in the Result Sheets for each student of various classes (Result Sheet 1A, Result Sheet 1B, Result Sheet 1C, Result Sheet 1D).
Hope my explanation is not comfusing.
I will be very much greatful, if you could solve my problem.
Thanks alot.
Bookmarks