Formula Question

Annick

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.

Paul Newcome

How exactly are you inputting the time?

Annick

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.

Paul Newcome

You could use an AVG/COLLECT combo such as

=AVG(COLLECT(Duration:Duration, Assay:Assay, @cell= "X"))