yogi_Compute Row By Row Average Score In Column L For Q1_Scores In Columns G and J

                                         Google Spreadsheet   Post  #1571
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-24-2014
post by CathyL16 question by GimelG  (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/1udpQ-HOvjw)
Alternative to CONTINUE function in new sheets

Hi everyone,

Is there a way to automatically copy a formula down a column without showing the "#N/A" or "#DIV/0" and without having to continually copy for new rows? 

https://docs.google.com/spreadsheets/d/1tv2c8VtHKyPnl-GL87EK7hwU4t-evKXUdV6UN31r6L8/edit?usp=sharing

I posted previously and was helped tremendously in setting up the formulas in the "Combined" sheet. Is there a way to have the formulas copy down? It seems to work well for the first cell, but not the others. I tried to use the ARRAYFORMULA function, but that didn't work. I've seen the CONTINUE function work in the old sheets, but read that this was discontinued in new sheets.  I'm using the new version of sheets as that allows me to have two forms links to the same spreadsheet. 

Is there a workaround?

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