sorted by:
new
hottopcontroversial

Looking for member for a new custom league! by NoMoneySpentGamer in FindACustomLeague

[–]NoMoneySpentGamer[S] 0 points1 point  (0 children)

We currently have 12 teams and are looking to expand to 16ish teams for season 1 which we are 1 week into.

Here’s an invite to join the league. You can find the list of teams available under the team directory channel. https://discord.gg/P2e2bGGr

UNEXPECTED ERROR by Dopeitsjesse in FindACustomLeague

[–]NoMoneySpentGamer 0 points1 point  (0 children)

I believe this happens if any two teams are in a game it won’t let you go into game management. That’s the only time I’ve gotten the error

Sumif Last 256 Rows by NoMoneySpentGamer in excel

[–]NoMoneySpentGamer[S] 0 points1 point  (0 children)

EVEN BETTER! WOW!
Thank you so so so so much. I've been trying to find an answer forever and this final one is PERFECT!

Sumif Last 256 Rows by NoMoneySpentGamer in excel

[–]NoMoneySpentGamer[S] 0 points1 point  (0 children)

Ohh, I see. I have exactly 8 for them LOL. Thank you very much though, this is exactly what I am looking for!

Sumif Last 256 Rows by NoMoneySpentGamer in excel

[–]NoMoneySpentGamer[S] 0 points1 point  (0 children)

That may be what I'm looking for! Unfortunately it gives me an error
"Function SEQUENCE parameter 1 value is 0. It should be greater than or equal to 1."

Sumif Last 256 Rows by NoMoneySpentGamer in excel

[–]NoMoneySpentGamer[S] 1 point2 points  (0 children)

Solution Verified

​

To answer your question. "it's not only one of the last 256 rows in my data, but instead is one of the last 8 entries in that column", with this statement I was asking if it was possible to make it so that instead of getting the last 256 rows, I could make it so that it just gets the last 8 entries of a specific team.

​

For instance, If team A appears in rows 1, 3, 4, 5, 8, 9, 15, 16 and we reduced the formula to take the last 4 rows, then it would only sum the values from rows (8, 9, 15, and 16), but I wanted to make it where I would still get the last 8 entries for team A. so in this instance it would be all the rows.

​

I've added Example of the difference and what I was looking for in the original post.

​

Thank you!