I have a spreadsheet that is filled by experimental data. The number of data
points (rows) can be 300-6000. I am tasked to take 50 point averages at the
25% and 75% points of the data. I can get the number of data points using
using the COUNTIF function. I need to be able to adjust the AVERAGE function
based on the COUNTIF results. Is there a way to set the cell reference based
upon this result? Are there any other ideas as to how to solve this? If my
problem is not clear, please ask questions.