cell reference math

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
JR,

How about these, for data in column A, and a title value in cell A1

=AVERAGE(OFFSET(A1,COUNT(A:A)*0.25-25,0,50,1))
and
=AVERAGE(OFFSET(A1,COUNT(A:A)*0.75-25,0,50,1))

HTH,
Bernie
MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CELL REFERENCE MATH 1
Cell Reference Math 5
Excel Need Countifs Formula Help 0
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 7
Average of top x% of a list 1
Finding the weighted average of text that have been given values 1
count if equal to not working? 1
COUNTIF Question 12

Back
Top