Formulas are incredibly long, there has to be a way to clean them up...

Originally Posted by Glenn Kennedy

You long formulae are incomprehensible.

As a start, I changed the formulae in O and P to look like this:

=SUMPRODUCT(--(Taxable!$C$3:$EC$3="Gain/Loss")*Taxable!C4:EC4)

Please MANUALLY check the two red cell results. These differed from the values that you showed. I suspect that I'm right and you're wrong... but I'll leave that to you.

Then in BABY STEPS, you need to explain the monster formulae. Start with the one in G4.

In simple terms, what the hell is it meant to do???

You are correct, your values in Column P are capturing a broker I was missing. Thank you.