Quadrant calculation formulas based on single cell value

Hi all,

Apologies is this post/thread is redundant as I could not find exactly what I needed in previous threads.

Please see attached.

I have a field of data from different quarters including budget information, and to save time and energy I am hoping to find formulas and calculations in cells I6:K9 that are based on which quarter is entered in line 4 of the respective column.

Some of the calculations are easier than others, but most are too complex for my current skill set.

If anyone has any solutions or recommendations please let me know.

Thank you in advance.

Thank you Paul! This is perfect and working wonderfully within my larger sheet.

I tried to recreate your sumproduct function for another task and it hasn't been working. I cannot figure out why. Could you please look at the simplified attachment and let me know where I am going wrong???

Any advice would be greatly appreciated.

Many thanks!

It took some editing to make this work in my larger sheet but your warnings were apt and your formula spot on. Thank you!!!