Thursday, June 20, 2013

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

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