if averageA function

[WINDSEAKER]

Im trying to figure out an average function for data loss in a spreadsheet with a nested if as well.
Its a common "reset" issue with meters. I have figured out a simple nested if for any "roll-over" known meter values but not a full unpredicted blank "reset" issue.

Any guidance is welcome.



Ifaverage function

[ChemistB]

I think I'm following the formula in E27 but to be sure could you update it to refer to C,D and E instead of AU and AW?

[ChemistB]

Okay, what I think you are trying to do, if the value in C is less than previous value, then sum all occurances in E since last reset plus the current value in C and divide by count of those values (including counting current value in C). Do I have that right?

Here's what I did, In F5 copied down
=IF(C5<C4,1,"")
In E6 copied downd

=IF(C6="","-",IF(C6<C5, (SUM(INDEX($E$5:$E$5, MATCH(1, $F$5:$F5)):$E5)+C6)/(ROW()-MATCH(1,$F$1:F5)+1), C6-D6))
See attachment