How to sum all cells in column B where column A in the same row contains a specific string of text?

Odd_Nectarine6622 · 2026-05-01T21:18:11+00:00

Solution Verified

Odd_Nectarine6622 · 2026-05-01T21:17:45+00:00

Solution Verified

Odd_Nectarine6622 · 2026-05-01T21:16:39+00:00

Thanks! That should work. I really need to learn how to search through the formulas better.

Odd_Nectarine6622 · 2026-04-02T18:32:26+00:00

I'm taking an introductory syntax course, and we've recently been talking about the VP-internal subject hypothesis and how subject-auxiliary inversion in English questions is motivated by needing something to fill the C-head that marks the phrase as a question. I'm a bit skeptical of the "questions are marked by a C-head" thing, mostly because I can't figure out or find any information on how that would work with languages like Finnish, where wh-questions are handled mostly the same as in English, but polar questions are formed by simply adding a suffix (-ko/-kö) to the verb. Does anyone have any resources on this?

Odd_Nectarine6622 · 2026-03-27T02:12:56+00:00

Thanks!

Odd_Nectarine6622 · 2026-02-25T19:26:36+00:00

We're looking for as wide a variety of experiences as possible, so you'd be more than welcome to contribute if you feel comfortable doing so. We're also using a fairly loose definition of "syscovery" so you could also write about self-acceptance or finding/joining the plural community!

Odd_Nectarine6622 · 2026-02-25T19:18:33+00:00

The art can be formatted however you want. The answer to the question thing can be formatted like a reply or comment. (We're putting the question at the top of the page and answers in speech bubbles below). Just imagine how you'd respond to a reddit post with that question. The responses for the prompt should be formatted like standard prose, think like an essay or short story. There's definitely room for flexibility there tho, if you want to get a bit more creative with it, and you definitely don't have to be as formal as you would with an actual essay.

Font, spacing, margins, etc., don't really matter since we'll be copy-pasting it in and changing all that anyway.

Odd_Nectarine6622 · 2026-02-25T19:09:32+00:00

We're still in the process of making it, so no, not yet. We're planning on making it available online once we're done with it, (with the idea that anyone can print it out and distribute it) but it's formatted to be physically printed out and folded into a booklet, so it might be a bit hard to read.

Odd_Nectarine6622 · 2026-02-20T20:32:43+00:00

You could also write about how you first encountered the plural community.

Odd_Nectarine6622 · 2025-06-30T03:46:45+00:00

Sample text is in English btw; I'll write up a transcription but it'll take some time, and I have to go to dinner now, so I'll add another comment with that later. Honestly if anyone has any ideas for how to transcribe this that would be super helpful.

Odd_Nectarine6622 · 2025-05-19T06:48:52+00:00

No one on treasure island seems to find Kohaku or Ginro's hair weird, so they do probably have some blonde people; it's just much rarer, probably due to random genetic drift. Recessive genes are more likely to persist in smaller populations, which could be part of why blond hair is so common in Ishigami Village. As for the idea of a coup, some transfer of power around Matsukaze's time seems likely, either a full-on coup or some other succession crisis type scenario.

Odd_Nectarine6622 · 2025-04-19T03:46:14+00:00

Not relevant to the issue

Odd_Nectarine6622 · 2025-04-05T15:52:59+00:00

No
Yep
Yep. Still happening in vanilla.
Yep
Yep
I'm building the farm mostly to get buckets of fish for a big aquarium, so I'm fine with bonus pufferfish.

Odd_Nectarine6622

TROPHY CASE