Forum Discussion
Calculate Average Up Periods and Down Periods
Good afternoon, all. I am doing an analysis on data going back to 1984 (monthly data). The data set has positive and negative numbers. I am trying to create a formula that will go through all the d...
Assuming you have real Number values (not Text values) formatted as %ages:
With the above setup, in C15:
=AVERAGE( FILTER( C2:C13, C2:C13 >= 0 ) )If you wan to exclude 0s, change >= with > in the above formula
In C16:
=AVERAGE( FILTER( C2:C13, C2:C13 < 0 ) )