Google Spreadsheet Post #1178
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May 08, 2013
user Anna Project Tech Nick (https://productforums.google.com/forum/?hl=en#!category-topic/docs/spreadsheets/PIO43KKDubc)
counta autofill array
I am using a form to input data into a sheet so the first sheet i can't edit, so i have a second sheet for organizing the data. What i am trying to do is autofill the formulas as new data is entered into the "Form Responses" sheet. The first formula i am currently using is =CountA(Iferror(Filter('
let us have a look at the following