conditional averages

Hey all, I am looking for some help creating a formula to analyze some health data that I am looking at. I have a range of testing dates for a preventative screening and I am looking to calculate the average of the 2 highest values separated by 21 days. I will attach a sample spreadsheet of an...

Hello, I have 5000 real numbers in Column A and 5000 real numbers in Column B. I would like to average the numbers in Column B when the number in Column A are between 5.0 and 10.0. Please could you help me with this and provide some hints? :eeek: Thanks in advance! Djordje

Hi All, I am trying to calculate average for values in a range of data that fulfill a certain condition viz. >1000 & <=5000. I am aware that the Averageif function can do the job, however I was unable to figure how to apply it in this particular case. Any help on this is appreciated. Thanks...

Good morning everyone, I have used this forum in past and this is a life saver site :) I hope to get answer this time as well.......... So.. here what I am trying to do.. I am using Excel 2010 and I have average of performance that is in percentage example 18% on C3 and the rest of the column...

Hello I'm searching for an equivalent of the "sum if" formula that averages the values if the condition is found instead of summing them. Any ideas anyone?

Dear Excel Ninjas, I'm looking to write a formula that ignores cells that have "NA" in them. The exact formula is: =F8/((B8/B12)+(C8/C12)+(D8/D12)+(E8/E12)) The catch is that if any of those cells within the parenthesis have a value of "NA" then that divided pair should = 0. So if B8 =...

Note first off the "AVERAGEIFS" function does not seem to work for what I want to do. I have a table containing dates, employee numbers, and total weekly hours (payroll hours). Every week, I update the table with the latest payroll hours for the employees. I need a formula that will average...