Friday, October 26, 2012

yogi_Make Computed Columns For User Specified Computations Over Many Columns


                                           Google Spreadsheet   Post  #829
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Oct 26, 2012
user Roi RRR said: (http://productforums.google.com/forum/?zx=r3nme9qg99cb#!category-topic/docs/spreadsheets/pDb-riZoDLA)

Generating the same formula with every new row 
I have a quality assurance questioner were the answer can be either yes or now  
When a form transfers data to its spreadsheet, it adds a new row but does not use the formula that I put in the previous record row.

I would like to add a new COUNTIF formula for each new row populated by the form in order to count the Yes's on every row.

---

I redid the sheet on my personal google account in order to provide you guys with permissions:
https://docs.google.com/spreadsheet/ccc?key=0AlKmvcLrAW2OdGJnN293d2tiTWZjS1R5S0dKcFVEQmc

---------------------------------------------------------------
following is a solution to the problem