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    Oct 26, 2012
user Roi RRR said: (!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:

following is a solution to the problem