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 

```
      (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

```

Now My requirement is to create a pivot table with two columns 

* column1 should have 3 rows with Person1,Person2 and Person3
* column2 should have sum of the share of amount each person is having

```
Name          Sum
Person1       200
Person2       400
Person3       200

```