Average non-adjacent cells in column

I need to find an average for this column, excluding cells with 0 and the sub-totals in row 18 and 30. Can anyone help? I can exclude the 0's but am stuck when trying to average the non-adjacent cells.