yogi_Create A Cross Tab of Status 'Attribute' By Name And Chart The Results

                                          Google Spreadsheet   Post  #1255
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun 20, 2013
user Sim S (http://productforums.google.com/forum/?zx=1un23xjfx15h#!category-topic/docs/spreadsheets/4q9DqWOkk1U)
google spreadsheet formula help
im trying to make a chart with the results below is link for the test spreadsheet

https://docs.google.com/spreadsheet/ccc?key=0AohCW4cNeekhdGczSFNxdksyNklvYzRaX0tNUVc3Z2c#gid=1

so as you could see spreadsheet has names and status

what i'm trying to do is add the total numbers for each persons name with it's status

example: 

james closed

james closed

so results column under closed will have right next james with number 2  

column "closed" number 2

column "hold" number with 0

column "open" number 1

thank you in advanced

---------------------------------------------------------------------------------------------------------------------------------------------