title: Excel Formula needed that will generate a sum and percentage based on a text value in a set of cells
body: <p>I need help generating a percentage.</p>
  
  <p>A1 = Sum(A2:A3)</p>
  
  <p>Cells A2, A3, A4 are numeric input for sum in A1</p>
  
  <p>Percentage in B1 ~~Calculation needed~~</p>
  
  <p>If I add a text Value in B2, generate the B1 Percentage from  related A2 number / A1 Sum</p>
  
  <p>If I add a text value in B2 &amp; B3, generate the B1 Percentage from  related A2 + A3 sum numbers / A1 sum.</p>
  
  <p>This could continue for 10-20 rows. I am entering in dates into column B. If a date is present in that column I want to update the Percentage of records in B1 by getting the corresponding numbers from Column A (A1 is the total and A2 and below are all input numbers).</p>
  
  <p>Can anyone help?</p>