Spreadsheet: 705517d1606161458-return-the-next-value-in-a-list-after-a-specific-value-is-found-help-find-the-next-value-in-a-list-after-sa_1
Sheet: Help Needed (2)

 | Goal:
 | I need a formula for the yellow cells in Column "K". I'm stuck on call K21. I need the formula to recognize "SG" in column "C" then determine if the next value AFTER "SA" is either a T, h, S, or SG. Then sum to that value and omit any rows with a "V" or "X" in column "E".
 | Item to Note:
 | To condense my formula, I added an extra row at the bottom of my sum list to include an "h". This will solve any situation where a "h" is the last block before a "T".
 | My [NAME] (so far) is in column "K". I am stuck at K23 which is the "SG" string.
 | [NAME]:
 | If | T | stops summing at… | T |  | Skip over h, S, SG, SA
 | If | h | stops summing at… | T or H |  | Skip over S, SG, SA
 | If | S | stops summing at… | Any Value T, h, S, SG, or SA
 | If | SG | stops summing at… | T, h, S, SG |  | Skip over SA
 | If | SA | stops summing at… | Any Value T, h, S, SG, or SA
 |  |  |  |  |  |  |  |  |  |  |  |  | Summing Visual (omit rows with "v" or "x")
 |  |  |  |  |  |  |  |  |  |  |  |  | For this sequence only. Other block variations will have differeent ending points for h, S, SA, or SG
 | [NAME] | Helper Row | Variables | Titles and Line Items |  |  |  |  | My [NAME] (So far…) | Short Math | Long Math |  | T - | ●  h | S: | * SG: | ` SA
 | T |  |  | Company Supplies - |  |  |  |  |  |  |  |  | T
 | h |  |  | Marketing Supplies |  |  |  |  |  |  |  |  |  | h
 | s |  |  | Event Supplies: |  |  |  |  |  |  |  |  |  |  | S
 |  |  |  | Computers |  |  |  |  |  | 200
 |  |  | V | [NAME] |  |  |  |  |  | 100 |  |  | v | v | v
 |  |  |  | Software |  |  |  |  |  | 200
 | SG |  |  | Event Supplies for Online Events: |  |  |  |  |  |  |  |  |  |  | * SG: | SG
 | SA |  |  | Online Event AAA: |  |  |  |  |  |  |  |  |  |  |  |  | SA
 |  |  |  | Line item for Event AAA |  |  |  |  |  | 200
 |  |  |  | Line item for Event AAA |  |  |  |  |  | 200
 |  |  | X | Line item for Event AAA |  |  |  |  |  | 200 |  |  | x | x |  | x | x
 | SA |  |  | Online Event BBB: |  |  |  |  |  |  |  |  |  |  |  |  | SA
 |  |  |  | Line item for Event BBB |  |  |  |  |  | 200
 |  |  | X | Line item for Event BBB |  |  |  |  |  | 200 |  |  | x | x |  | x | x
 |  |  |  | Line item for Event BBB |  |  |  |  |  | 200
 | h |  |  | Operation Supplies |  |  |  |  |  |  |  |  |  | h |  | h | h
 | S |  |  | Office Supplies: |  |  |  |  |  |  |  |  |  |  | S
 |  |  |  | Tables |  |  |  |  |  | 100
 |  |  |  | Chairs |  |  |  |  |  | 100
 |  |  | V | Pens |  |  |  |  |  | 100 |  |  | v | v | v
 | SG |  |  | USA Offices: |  |  |  |  |  |  |  |  |  |  | SG | SG
 | SA |  |  | NYC Office: |  |  |  |  |  |  |  |  |  |  |  |  | SA
 |  |  |  | Line item for NYC Office |  |  |  |  |  | 200
 |  |  | V | Line item for NYC Office |  |  |  |  |  | 200 |  |  | v | v |  | v | v
 |  |  |  | Line item for NYC Office |  |  |  |  |  | 200
 | SA |  |  | Boston Office: |  |  |  |  |  |  |  |  |  |  |  |  | SA
 |  |  |  | Line item for Boston Office |  |  |  |  |  | 200
 |  |  | X | Line item for Boston Office |  |  |  |  |  | 200 |  |  | x | x |  | x | x
 |  |  |  | Line item for Boston Office |  |  |  |  |  | 200
 | H |  |  | End of Sheet
 | T |  |  | End of Sheet