Hello,

I am trying to create a spreadsheet that will take the average of each column. I don't want the #### to appear if there are no characters in any column rows. I want the formula to take the average of the column only if there are numbers between 1-5. Can someone please help me?

Thanks!