TRIMMEAN & OFFSET together

Hi ALL,

I need to use TRIMMEAN for the green & blue rows rather than SUMIF to reach less volatile result.

I guess I need to use OFFSET (like in cells L3-L5) but cant find a combination that works.

The range C7-G1000 will be getting added to daily.

If at first you dont succeed try another 10,000 times. I think I've solved it myself after spending hours trying a million & one combinations.

I have uploaded what I think is correct for others to see.


Just call me Missy Excel