Average table stat based on three cells

[nsmjc]

I posted a similar question a while ago which was answered and the solution worked this is a bit different as it involves the reference data to average on 2 of the cell

So I have a table with 3 columns I need to separate and average data from the table based on the data in three columns which would appear in cells not in the column.

Team Time Task

I need Task 1 Alpha average in cell E2

I need Task 2 Alpha average in cell F2

I need Task 1 Bravo average in cell G2

I need Task 2 Bravo average in cell H2

I tried the formula and variations with out luck any ideas?

=Iferror(AverageIFS(Table1[Team],"Alpha",Table1[Task],D2,Table1[Time]),"")

We are using a table as it is easy for a user to sort large amounts of data

[FDibbins]

So I have a table with 3 columns

Did you upload the correct file? That file only has 2 columns

[nsmjc]

Did you upload the correct file? That file only has 2 columns

Of course not that has been my day attached is the correct one

[FlameRetired]

Try this formula in E2 and fill across.

=AVERAGEIFS(TASK[Time],TASK[Task],--MID(E$1,6,1),TASK[Team],RIGHT(E$1,5))

and format accordingly.