title: How to calculate weighted average for 0 values
body: <p>I am facing an issue in performing a weighted average logic in excel.<br>
  I am looking at 4 fields for different deliverables: Total, Complete, Pending and Weight.</p>
  
  <p>The weighted average for a particular deliverable is calculated as : (Complete/Total) * Weight for example ((5/10) * 0.20) = 10%</p>
  
  <p>For each of the deliverable, I have calculated the % and then added all of the % together.</p>
  
  <p>Deliverable 1 - 10 = 10% + 20% + 5% + .... = 65%</p>
  
  <p>My question is:<br>
  if for a particular deliverable, the available field is 'Not Applicable' or '0', then the weighted average for that deliverable will be 0%. There by, the total will be on a lower side. So, is there a better way to represent this? How can I solve this issue?</p>