Need help with a formula

[Fredirk]

Hello!

At work, the people are working on their orders in teams, so me and my co-worker want to keep track of those teams to see if we can mix them up and make it more efficient.

So my problem is.

Ex

Team	Start time	Stop time	Total Time	Min	Rows	Min/Row
T1	18:20:00	19:20:00	01:00:00	60	120	0,50
T2	15:20:00	19:24:00	04:04:00	244	200	1,22
T1	11:11:00	15:45:00	04:34:00	274	150	1,83
T3	09:00:00	17:00:00	08:00:00	480	420	1,14

In the bottom of the document I want a function that looks for "T1" in the A-collumn and then creates an average on every "min/row" of T1

[#2]

That is something that is easliy done using a pivot table.
Insert, Pivot table
Drag the Team field to the rows area
Drag the Min/Row field to the sigma area
Right-click the min/row column in the pivot table and choose "Summarize Values By" and select "Average". Done!

[#3]

@Fredirk 

You may simply insert a Pivot Table and drag the Team field in the Rows area and the Min/Row field in the Values area and change the Value Field Settings to show the Average.

If you go for the Pivot Table approach, it would be better if you convert your data into an Excel Table and then insert a Pivot Table based on this table so that when you add/delete data in the table, once you Refresh the Pivot Table it will always show you the updated report.

Please refer to the attached which contains a Pivot Table solution and the formula solution as well.