title: VBA Calculate percentage
body: <p>So i need some help. Im pretty new to VBA so im having some trouble.
  Well i have multiple sheets in my work book (excel). what im trying to do is, calculate the percentage of how many cells have the word "IMCOMPLETE" in column D and putting the outcome in the main sheet on a certain cell. Example:</p>
  
  <pre><code>Sub Get_Percentage()
  
  If Range("Jackson,_Mr._Vince_R.TrainingSt'!D2:D100").Value = "IMCOMPLETE" Then
      put outcome in "TotalSummery%"!E2
  If Range("Carter,_Mr._Oscar_R_(Oscar)Trai'!D2:D100").Value = "IMCOMPLETE" Then
      put outcome in "TotalSummery%"!E4
  If Range("Taravella,_Mr._Jim_(Jim)Trainin'!D2:D100") Value = "IMCOMPLETE" Then
      put outcome in "TotalSummery%"!E5
  
  End Sub
  </code></pre>
  
  <p>FYI: I have like 10 sheet tabs. Not sure if this would be a macro.</p>