Add a column, Then average the sum by a cell

Hi guys,

I'm wanting to add a column, then divide the sum by a number in a cell lower down in the same column.

For example,

Add B1 to B30
Then Divide that total by the number in B35
The number in B35 will change over time

Is this possible?

Drew