Macro or formula to total sum

[aehartle]

I am looking for a formula or a macro that will total the amounts above it (no spaces)and then divide by 80. I have multiple positions in the company and currently going to the end of each group sum(range)/80. Very time consuming. Just wondering if there is a formula or a macro that will go to the end of each group(no spaces inbetween people) and sum(cell directly aboveshift+ctrl+up arrow)/80.

Any ideas?