Using OFFSET For Dynamic Ranges Along With SUMIFS?

Good afternoon, Gurus (JeteMc specifically!)

I’m reopening this thread because the ask for the project has changed a bit and what I thought was a simple adjusting of the formula has put me back in a predicament.

The solution JeteMc offered in his solution worked fine, but the criteria have changed slightly; I’m now trying to identify “Flow” as anything with a VI of “-“, “TR” or “OR”, and any SUMIFs by any of those individual values works, but when I try to SUMIFS using more than one (per the attachment, it returns “0” for Flow. What gives??

Thanks in advance for any help!