Quick/Simple problem: Average function based on filtering rows? (please help!)

*In row 32 I would like to type a number from the range in the same column above and have it filter only rows with that value before generating the average of each column and displaying the result in row 33. (Note: I don't need any of the rows to be hide/re-appear - just for averages to change as I change value in any row 32 cell)

For example, if I type 2 in A32 then I am only interested in finding the averages of the following rows/colums:

2 3 0 6 10 1 0 11
2 3 0 1 5 0 3 9
2 3 0 0 4 0 1 10

The results should then display in row 33 (except maybe for in A33; that doesn't necessarily have to show anything):
2 3 0 2.333333333 6.333333333 0.333333333 1.333333333 10

Any help would be much appreciated!

\1
http://www.filedropper.com/book2_4 (download workbook)
Book2.xlsx