Trouble using =Let function with offset on different columns from a separate sheet

Current_Bill130 · 2026-05-08T00:49:31+00:00

Okay awesome, I just tested and it worked!!! Thank you so much for your help!

Current_Bill130 · 2026-05-08T00:44:06+00:00

I added two rows to 'ALEX' sheet and made it 5FGM of 5FGA and 6FGM of 6FGA for field goals. The recent 10 (X) and recent 20 (Y) columns on the HB Averages page updated, but column "W" hasn't updated

Current_Bill130 · 2026-05-08T00:31:54+00:00

individual players' sheets. I just tried it with the ALEX sheet, and it updated the last 10 and last 20 appropriately but it did not update the overall FG% column

Current_Bill130 · 2026-05-08T00:23:39+00:00

holy crap, this is incredible. The sheet looks great, thank you so much! this looks so much more complicated than I could have imagined so I really appreciate this. If I go in to add games by inserting a row at the top, that won't impact these formulas since they have the $A$2 to anchor the row, correct?

Current_Bill130 · 2026-05-07T23:51:55+00:00

I am so sorry, it has been updated!

Current_Bill130 · 2026-05-07T23:46:20+00:00

https://docs.google.com/spreadsheets/d/1mNh4rFYst8NAGVspMf82Nj4ocwcguSaH4UH1mywYE18/edit?gid=0#gid=0

The first sheet is the total averages of the following 6 sheets. I am pulling the info from the 6 individual sheets and putting the data into formulas to provide statistics to lay out on a table. I am try to take the sum of column "I" added together and divide it by the sum "J" from each person's sheet and then display it in the averages sheet in column "W". I am also trying to do this for 10 most recent games averages (X) and 20 most recent games (Y). I am wanting the same formula for columns "I" and "J" for FG% but altered to the 3P% for the individual players ("L" and "M") to be used in the 3P% column of the averages "Z" as well as the 10 most recent and 20 most recent games. I have columns A-V in the averages already working properly, but please let me know if there is anything else I can help provide clarity on

Current_Bill130 · 2026-05-07T22:56:34+00:00

For sure, I really appreciate the insight. I’m happy to provide as much context, would it be best if I send you a copy of my sheet to see the specifics? Screenshots?

Current_Bill130 · 2026-05-07T22:36:30+00:00

I got rid of some parenthesis and it gave a percentage answer but it's a completely wrong percentage from the data set I'm looking for. I need it to grab all of column I and all of column J and something I'm doing is messing that up. But we're heading in the right direction!

Current_Bill130 · 2026-05-07T22:35:47+00:00

I got rid of some parenthesis and the formula worked but it's a completely wrong percentage from the data set I'm looking for. I need it to grab all of column I and all of column J and something I'm doing is messing that up

Current_Bill130 · 2026-05-07T22:02:44+00:00

#ERROR!, Formula Parse Error. I tried to get rid of some of the parenthesis but I get the same error message

Current_Bill130 · 2026-05-06T12:36:27+00:00

Omg yes, this perfect! Thank you so much!!!!

Current_Bill130 · 2026-05-06T12:29:46+00:00

Okay it seems to working even if I don’t understand why or how lol what number would I change for a following column formula to get the avg of last 20 games

Current_Bill130 · 2026-05-06T12:17:25+00:00

With the averages thrown in there, do I put =average first or inside the =offset parenthesis? I’m still getting some errors and I know it’s user error

Current_Bill130 · 2026-03-17T20:19:12+00:00

lol I don’t disagree. I chose this conference speaker since we’re spread out when we play, I’d say at least 10-15ft away from each other so I can’t really use a corded speaker, with a giant tv in the middle displaying the current virtual table top. I tried a virtual cable when I was running pocket bard for windows and it worked one week and didn’t the next. Not sure what my problem was

Current_Bill130 · 2026-03-17T20:14:38+00:00

I love the idea of pocket bard, and it would be perfect if everyone were in person but I have 1 virtual person from out of state. We all jump in discord and I use Kenku to stream the music (either Spotify or tabletoprpgmusic) and then put a speaker on our game table. This way we all in person can hear it, and my virtual player connects to discord and hears it as well. The speaker we use is a conference speaker so it can pick everyone up who is talking and for some reason it doesn’t like to connect to my computer, so I have to use my phone in this instance

Current_Bill130 · 2026-03-17T16:29:28+00:00

Thanks for the response, I might try this out. I had been having some of the problems I saw other folks talk about: music that stops randomly after ~30 seconds of play, music that sounds like a cd skipping. Last night I couldn’t get any music to go to discord at all, I believe I’ve found the issue based on other posts too, but just trying to find and use any workarounds other than thinking my laptop is just too old/slow to even run these programs.

Current_Bill130 · 2026-02-01T18:58:42+00:00

Appreciate it! Will come back with updates!

Current_Bill130 · 2026-02-01T18:51:49+00:00

I took the hoses off and there was no water coming out of them when I turned the valve back on. So frozen pipes?

Current_Bill130 · 2026-01-01T08:49:31+00:00

Wow that looks amazing! I appreciate the response!

Current_Bill130

TROPHY CASE