title: Excel Pivot depending upon Header values
body: <p>I am trying to create a Pivot table in excel and below is my scenario. 
  I have an excel sheet with 5 columns where columns 1,2,3 is having 3 different persons names( person1, person2,person3) as header and it's corresponding values will be either 'yes' or 'No'. column 4 is having amounts and columns 5 will have the share for each person. The share is calculated depending on the value(yes/No) that was present in the 1st three columns and the formula I am using for this is </p>
  
  <pre><code>      (D1/COUNTIFS(A1:C1,"Yes")) 
        i.e., dividing the (amount/ count( of persons having Yes value))
  
   Person1    Person2 Person3 Amount  PerHeadShare
   Yes        Yes     No       200         100
   Yes        Yes     Yes      300         100
   No         Yes     No       200         200
   No         No      Yes      100         100
  </code></pre>
  
  <p>Now My requirement is to create a pivot table with two columns </p>
  
  <ul>
  <li><p>column1 should have 3 rows with Person1,Person2 and Person3 </p></li>
  <li><p>column2 should have sum of the share of amount each person is having</p>
  
  <pre><code>Name          Sum
  Person1       200
  Person2       400
  Person3       200
  </code></pre></li>
  </ul>