{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Ch","Width","Avg Width","Area","Avg Area",null,"Helper Column",null,null,null,null,"I want the formula which gives average of the value, "]
[10,5,{"$f":"IFERROR(IF(G2<>\"\",AVERAGE(OFFSET($B2,-(G2)+1,,G2)),\"\"),\"\")","v":5},null,null,null,1,null,null,null,null,"the formula will select the whole column (i.e Column B)."]
[{"$f":"A2+10","v":20},{"$f":"B2+5","v":10},{"$f":"IFERROR(IF(G3<>\"\",AVERAGE(OFFSET($B3,-(G3)+1,,G3)),\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,"there will be a value, in helper column (G),"]
[{"$f":"A3+10","v":30},{"$f":"B3+5","v":15},"",null,null,null,null,null,null,null,null,"With reference to the helper value, the average will calculated."]
[40,{"$f":"B4+5","v":20},12.5,null,null,null,4]
[50,{"$f":"B5+5","v":25},"",null,null,null,null,null,null,null,null,"Ex."]
[60,30,"",null,null,null,null,null,null,null,null,"if I provide value 2 in helper cell,"]
[70,35,"",null,null,null,null,null,null,null,null,"the formula will slct whole column, and calculate the average of 2 values which is in B column."]
[80,40,37.5,null,null,null,2]
[90,45,"",null,null,null,null,null,null,null,null,"Like if I want average in C9"]
[100,50,"",null,null,null,null,null,null,null,null,"in G9 (Helper Cell) - 2"]
[110,55,"",null,null,null,null,null,null,null,null,"then average should be calculated for the value of 2 cells B8:B9"]
[120,60,""]
[130,65,""]
[140,70,"",null,null,null,null,null,null,null,null,"like that if helper cell contains 3, the average should be of b7:b9"]
[150,75,""]
[160,80,""]
[170,85,""]
[180,90,""]
[190,95,""]
[200,100,""]
[210,105,""]
[220,110,""]
[230,115,""]
[240,120,""]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}