Calculating average of the column in a cell inside that same column
Getting average of what is above me and what is below me in my same column in one of the cells
DS2 has 1 to use as Average, anything else to get regular number from some calculation …
PH2 = IF($DS2=1, IFERROR(AVERAGE(PH$1:PH1,PH3:PH$110),"N/A"), "Other numbers")
This is mainly to avoid circular references when using Average(A:A)
