Averaging Cells Using Table by Group and Result

Hi, All.

I am trying to find a formula that will average a range of cells in a table (Table1) dependent on group and result.

I thought that I would be able to tweak a previous formula that I got from this forum but I can't seem to get it to work.

I have attached some dummy data in an excel file. Cell I13 in the Analysis tab is where I need the formula to average cells in the Results tab according to Group 1, 2, 3 etc and Results 1, Results 2, etc.

Ideally I would need the formula to reference Table1 as I have a number of additional tables in different results tabs in the original data.

Any help would be appreciated.

Many thanks for looking.