title: How do I get the average of consecutive positive or negative numbers into one cell?
body: <p><a href="https://docs.google.com/spreadsheets/d/1Z99BFJws_fjrY6Z143opVntSqI5t8vG8Dkyk5-zWx68/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1Z99BFJws_fjrY6Z143opVntSqI5t8vG8Dkyk5-zWx68/edit?usp=sharing</a></p>
  <p>A2:A16 is a column of the values
  C2:C16 adds up consecutive positive and negative values in the column but I would like a formula that could get the average of those consecutive values into one cell.
  H7 shows what should be the answer for the average of those 3 consecutive positive numbers.
  H13 shows what should be the answer for the average of those 4 consecutive negative numbers.</p>
  <p>Is there a formula that can do this?</p>