Guys

sorry, but one main thing i forgot to mention....the formula needs to "SUM" the values in the respective column eg. column BJ from RB1

The formulas listed above take the first value that shows up.

Any way to embed SUM into the formula?

thank you in advance.