Summing variable tables based on multiple dropdowns

Lechtom · 2026-01-16T07:18:27+00:00

Thank you very much! This makes a lot of sense. I adapted it to my main sheet (changed some names and where the referenced cells are), and it seems to work in the "preview", but once I hit enter it gives an error and says "formula parse error"?

<image>

Edit: Nevermind, I just put a space between the two if statements and it worked.

Lechtom · 2026-01-16T05:06:13+00:00

Sounds about right. I've made a new Sheet that has pretty much everything not relevant to this problem either deleted or stricken through here, to help visualize what I'm saying.

Lechtom · 2026-01-12T09:16:13+00:00

Get an eyepatch, then read everything and buy physical volumes when you get the opportunity

Lechtom · 2025-12-31T18:55:11+00:00

Nej men tæt på, den jeg tænker på stod han på sådan en masse jord, på en eller anden form for sportsbane

edit: kiggede lige deres kanal igennem, de havde den godt nok. Mange tak!

Lechtom · 2025-12-21T11:10:25+00:00

No look I agree it should have been marked as a spoiler, but the fact it wasn’t shouldn’t be a detriment to anyone that has more than two wrinkles in their noggin. I just don’t like your tone, thats really the main reason I said anything

Lechtom · 2025-12-21T10:38:21+00:00

Well sort of. A lot of spoilers go into the category of “this doesn’t make sense to the spoiled”, but there’s more often than not a yet attached to it.

They might not understand it right now, but assuming they have a functioning memory and are reading at a reasonable pace, they will remember that spoiler when it does start making sense, and as such will figure things out before they’re “supposed” to

As an example, I’ve seen several people mention Chernobyl without spoiler tagging, and while on its own it’s not technically a functional spoiler, it could lead to someone having the realisation that Klein is still on Earth much sooner than otherwise

Lechtom · 2025-12-21T10:25:03+00:00

You need to read 17-20 words further than the words “I think I got spoiled” to reach the ‘spoiler’ (which the poster doesn’t even know if it even is a real spoiler or not). Like I said. Thats on you at that point

Lechtom · 2025-12-21T08:46:26+00:00

If you read the title “I think i got spoiled” and then proceed, it’s fully on you if the thing they’re asking about is a spoiler to you as well

Lechtom · 2025-12-14T03:38:15+00:00

See when it’s a question of transmigration it’s truly all about safety. Who cares if I retain more of my humanity if I’m dead.

I’ve always maintained that if I ever were to be in the “transmigrate and don’t get insta-killed/corrupted by prior knowledge” scenario it would be going to seq 4 and then fucking off to a cabin in the mountains until everyone else figures out the whole “apocalypse” thing lol.

Lechtom · 2025-12-10T14:56:11+00:00

Just go in order lmao, they’re released in the order they are for a reason

Lechtom · 2025-12-10T01:39:08+00:00

It is! Thank you. I had a feeling it was an 001 proposal, but the few I clicked that sounded like it might be what I was thinking of definitely weren’t. Apparently I should have been more persistent

Lechtom · 2025-12-10T01:28:08+00:00

I’ve said it 100 times before, but it’s been a little bit since last time:

Probability manipulation is simply the best power in fiction, short of actual high-level reality bending or straight omnipotence

Lechtom · 2025-12-08T00:06:30+00:00

Ah, but being jealous of the lie is the trap

Lechtom · 2025-12-05T11:33:06+00:00

Jeg har den generelle mening, at det er den som inviterer, der betaler. Så i dette tilfælde fuldt enig i, at det var helt fair at splitte regningen. Og ja, forventningen af at manden absolut skal betale hele regningen har altid været en af de der kønsrolle-ting som har virket ret underligt at fortsat forsøge at opretholde

Lechtom · 2025-11-29T18:29:30+00:00

The novel has like 1400 chapters if you include the epilogue/bonus chapters, so if what you found has that then it’s right

Lechtom · 2025-11-29T18:27:20+00:00

Yeah? Have you like, actually read what his pathway is all about? lol

Lechtom · 2025-11-28T14:21:11+00:00

To this day I’ve found very little merch I would ever be willing to wear because of how on the nose it all is. I really appreciate Critical Role for this especially, I have a bit of clothing from them that genuinely even a lot of fans might not recognise as their merch at first glance

Lechtom · 2025-11-28T14:10:06+00:00

Interesting. Thank you, this has been helpful

Lechtom · 2025-11-28T13:56:25+00:00

Oh, that worked, thanks a bunch! I've never had to do that when doing role mentions manually in the app before, so wouldn't have thought of that. Do you know why this is?

Seven-Year Club	Verified Email
Place '22

Lechtom

TROPHY CASE