Without getting into some VBA macros to find the last row and insert formula, you can't do that too easily.

My suggestion would be to insert a row at the top of the sheet and place the formulas there that will summarize your data.


My previous formula(s) could be ammended to consider entire columns,

e.g. =COUNTIF($C:$C,"yes")/COUNTA($C:$C)

will count all yeses in column C and divided by number of cells containing any values in column C.... you would just subtract, from the divisor, the number of rows at top that contain headings, etc. so that you only account for the rows containing yes or no entries.