I actually made a serious attempt in creating the formula so it is a bit frustrating for me if it is not what you want. But it is difficult for me to understand what you write as you do not give examples of expected results (it may be due to the fact that English is not my mother tongue).
I attach a new version of the file where I have added QARVP1, QARVP2 and QARVP3 to Summary!C4:C6 and corresponding formulas in Summary!E4:E6
|