The first 25 percent
 

I have a multi-row, multi column spreadsheet. Of the columns, 3 of them are
the most crucial. Let's say,

Column A is: User

Column B is: Date

Column C is: Cycle Time (Calculated from B and another column)

What I would like to know is the average (median, etc...) Cycle Time for
the FIRST 25% (50%, 75% etc...) of the Users signed up.

Any ideas?

The first 25 percent
 

If by "first 25" you literally mean the first 25% of the entries (or if you
meant by date, you could do a sort) a formula to use might be:

=AVERAGE(OFFSET($C$2,,,INT(0.25*COUNTA(A$2:A$100)) ))

Change the 0.25 to 0.5, 0.75, or 1 to calculate the other percentages.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Rum" wrote:

I have a multi-row, multi column spreadsheet. Of the columns, 3 of them are
the most crucial. Let's say,

Column A is: User

Column B is: Date

Column C is: Cycle Time (Calculated from B and another column)

What I would like to know is the average (median, etc...) Cycle Time for
the FIRST 25% (50%, 75% etc...) of the Users signed up.

Any ideas?