I have made an attachment with information.
I want to be able to sum an entire row up to a certain column based on criteria. I have tried multiple methods and have failed. I am fairly proficient with array formulas and I am pretty sure it is possible. Hopefully one of you true experts can help.