conditional averages

  1. H

    How to create an excel formula that will average the 2 highest values that are separated by a 3 week difference in testing date

    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...
  2. D

    Average of values in Column B based on a criteria from Column A

    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
  3. K

    Conditional Average

    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...
  4. S

    Multiple Conditional Formula Formating

    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...
  5. D

    averageif for a range

    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?
  6. M

    Conditional Formula to ignore text fields.

    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 =...
  7. A

    Multi Conditional Averages

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top