Forum Discussion
Averaging data around cell in table, if cell equals zero
I am creating data tables for sensor readings taken each hour, each day, for a month. Sometimes data is missed due to recalibrations, resulting in a zero/blank value. I am hoping to automatically tak...
I was able to get this to work for what I need. Here is the formula base I used.
=IF('Gas201701'!$C30=0,AVERAGE(OFFSET(C7,-1,0),OFFSET(C7,1,0)),'Gas201701'!$C30)
C7 is the cell the formula is applied to, and C30 is the referenced value.
Hope this helps someone in the future.