To avoid volatile functions in C3
=(SUM($E3:$Z3)-SUM($E3:INDEX($E3:$Z3,MATCH(9.99E+307,$E3:$Z3)-3)))/3

and pull down as needed
Replace the 3 with seven for D3
Adapt ranges as needed

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post