AverageIf.xlsx

Aamir Hussain

<div>
I am very thankful for your expert opinion .Thats the exact output which i want .
</div>


<div>
<div class="content wysiwyg-content">
If one student is giving different series of test and each test carries 400 total marks of each test .<br />
E.g <br />
<br />
Test 1 : 350 <br />
Test 2 : 250<br />
Test 3: 0<br />
Test 4 : 390<br />
Test 5 : 0<br />
<br />
Total Marks will 2000 and obtain marks will 990 and percentage will 49.5 %. This is ok .<br />
<br />
But I want if student gave 3 tests out of 5 tests then Total marks will be base on &nbsp;3 tests and percentage should also be base on 3 &nbsp;tests .<br />
<br />
Kindly suggest me a formula for excel which can resolve my issue .
</div>
</div>


If one student is giving different series of test and each test carries 400 total marks of each test .
E.g 

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 .

Calculate Percentage on specific requirement

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.