Trying to find median & average for multiple columns with multiple criteria

Hey friends,

I am attempting to get the average and median, but i just cant write a winning formula. attached is the sample/dummy data and the spot where i need help is in the green transaction fundamentals table.

The blue table above it is fine as is....for clarity, the blue table pulls all data from the right into it and in theory the green one is supposed to pull only the complete data (meaning data that has calculations in ever single "named title" column)

cells C52:J53 are where i need help

please help ease my jumbled brain

i can try to clear it up more if i'm not making the most sense
Book33.xlsx