Greetings, I am pondering whether I can average some values using the AVERAGEIF formula. I record tank values on a daily basis, for the sake of this example we will say 0 to a 1000 gallons. Everyday we use between 50 and 100 gallons, and we refill the tank every 4-8 days or so. So the data table would be showing ~6 days of descending values and then 1 ascending value and then repeat. I am not necessarily interested in the exact daily average, just a rough average. The filling frequency cycle could change depending on usage rates so this is what is making it difficult to just make the average a 6 day average or something. The thought occurred to me that I could just RANK all the numbers first and then average them all out, but I don't think that would be proper.
If all the values were in a single column, is there a way to write the AVERAGEIF formula so that it only averages the values where the preceding number for it is higher, but ignores the values in which the preceding one before it is lower?
Appreciate any insight - thanks,
If all the values were in a single column, is there a way to write the AVERAGEIF formula so that it only averages the values where the preceding number for it is higher, but ignores the values in which the preceding one before it is lower?
Appreciate any insight - thanks,