u/Current_Bill130

I posted yesterday and got an answer that worked for a different problem but now when I am trying to use the =let function with offset to grab two columns data that is on a different sheet I cannot get past #ERROR!, Formula Parse Error.. My current formula is =LET(FGM ,OFFSET(Alex!I1:I,1,0,500) , (FGA), (OFFSET(Alex!j1:j,1,0,500),(FGM/FGA))), which gives me the error. If I get rid of the names from inside the LET function, I can get a percentage but only of the first row of cells. Please help!

Good morning, I’m not super adept with sheets I’m learning and I’m trying to make a formula on a primary sheet that is collecting a running average on different sheets. It’s for stat keeping basketball games, overall averages on sheet 1 and individual averages on sheet 2, and my plan was to add a new row to the top of sheets 2 on to also have a formula keep a running tab on the previous 10 and previous 20 games. Currently when trying to grab these averages, anytime I add another row to the previous game list it drops the range down with it. I’ve tried multiple formulas (could just have them typed in wrong I suppose) but I am at my wits end. Any help is appreciated.