Formula Question
In one column I have the assay type in one column (Assay X, y, X…) and in another column I have the time it took for this specific work. How can I write a formula that asks to do an average of the time it took for all of the occasion we performed assay "X". The different assays would be appearing on multiple occasion as different rows with each one of them having their distinct time.
Answers

How exactly are you inputting the time?

its a value calculated from two dates (Finish  Start) and divided by 7, to have number of weeks. Example the cell would indicate 0.51 (being approximately took half a week. The column is showing the result of that formulation calculation.

You could use an AVG/COLLECT combo such as
=AVG(COLLECT(Duration:Duration, Assay:Assay, @cell= "X"))
Help Article Resources
Categories
Check out the Formula Handbook template!