If one student is giving different series of test and each test carries 400 total marks of each test .
Test 1 : 350
Test 2 : 250
Test 3: 0
Test 4 : 390
Test 5 : 0
Total Marks will 2000 and obtain marks will 990 and percentage will 49.5 %. This is ok .
But I want if student gave 3 tests out of 5 tests then Total marks will be base on 3 tests and percentage should also be base on 3 tests .
Kindly suggest me a formula for excel which can resolve my issue .