Jazz M
New Member
- Joined
- Jun 8, 2018
- Messages
- 11
Hi folks, I am running a marking centre this weekend and I wish to sum track 'live marking' of exams over the course of the day.
I have 3 teams, each correcting one exam (Exam A, Exam B, Exam C). However I only wish to see a candidates overall result once a score has been posted to each of the Exam cells.
Can you help me write a formula that will only sum the 3 cells if there is a score present and not perform the calculation if there is not a score in all 3 cells ?
The example below in the first instance there is no score for Exam C so i dont wish for an overall result to be totalled. However in the second instance there is a score recorded in all 3 exams so i wish for the overall result to be recorded.
there are thousands of candidates so hence looking for a formula.
thanks as always in advance folks.
<tbody>
</tbody>
I have 3 teams, each correcting one exam (Exam A, Exam B, Exam C). However I only wish to see a candidates overall result once a score has been posted to each of the Exam cells.
Can you help me write a formula that will only sum the 3 cells if there is a score present and not perform the calculation if there is not a score in all 3 cells ?
The example below in the first instance there is no score for Exam C so i dont wish for an overall result to be totalled. However in the second instance there is a score recorded in all 3 exams so i wish for the overall result to be recorded.
there are thousands of candidates so hence looking for a formula.
thanks as always in advance folks.
Jazz M
<tbody> </tbody> |
<tbody>
</tbody>