Averaging Cells Using Table by Group and Result

[cosmica67]

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.

[Fluff13]

Shouldn't that be H13 at the end of the formula not G13

[cosmica67]

And that is where I've gone wrong!

Couldn't see the wood for the trees......

Many thanks for pointing that out, Fluff13.

[Fluff13]

Glad to help & thanks for the feedback.

[sandy666]

optional way with Power Query

Please Login or Register  to view this content.

Group	Avg1	Avg2	Avg3	Avg4
1	55.38596491	55.84210526	49.47368421	69.01754386
2	46.55932203	42.18644068	51.42372881	55.88135593
3	52.45614035	57.89473684	67.57894737	51.15789474
4	56.78947368	61.92982456	69.75438596	59.96491228
5	54.75	52.03846154	59.5	65.03846154

[cosmica67]

Many thanks for this.

It's certainly something for me to consider as it looks very efficient.

[sandy666]

You are welcome