averageif function

  1. R

    Need to average 3 non continuous cells based on text in a different cell

    Hi. Thanks in advance! I'm trying to average cells F13, F20 and F27 but I only want to count any of them if their associated cell above it (F12, F19 and F26) contain the words "Dilution Used". If Dilution Used does not appear in F12, F19 or F26, then I don't want to include the associated cell...
  2. T

    AVERAGEIF question

    I want to average all cells in a row based on the day of the week in another row and I only want it to include cells greater then 0. Essentially for the average returned in R2, the range is A2:N2, if A1:N1 is Sunday, return average for sundays and only include in the average if cell in row 2 is...
    • Tazzbjs
    • Thread
    • average averageif function row sunday wednesday
    • Replies: 3
    • Forum: Excel Questions
  3. R

    Average of Last 5 values from cells with a formula

    I have a spreadsheet with loads of data for fantasy basketball. I want to be able to calculate the average of the last 5 games of a player's fantasy scores. My column that records the scores is based on a formula drawing data from other cells and creating an aggregate score. So the points...
    • roju23
    • Thread
    • average averageif function cell cells formula
    • Replies: 2
    • Forum: Excel Questions
  4. G

    Change formula to include rows less than today's date

    Hi All, I have this formula which was provided to me and sorted one problem out which was great. Now I need to adapt the formula so that instead of excluding rows with today's date, I want it to now only include rows with today's date. How do I adapt this formula so it is only including the...
  5. H

    VBA: AverageIf

    Hello, I have worked out below standing code, but it's ignoring the AverageIf part of it. What did I do wrong here? The cells (average) remain empty without error message. Thank you for your help! Regards, Hans Netherlands ..................... Sub ReturnLeadTime() Dim Data As Worksheet...
  6. W

    Average based on the Percentile and two other parameters

    I'm trying to create a formula which calculates an average for array 2 if another the values from array 1 are within a percentile range, the values are based on the same year, and the state matches parameter #2. I've tried several different versions of the percentrank to identify the percentile...
    • wtsabo
    • Thread
    • average averageif function averageifs percentile
    • Replies: 0
    • Forum: Excel Questions
  7. F

    Averageif query

    Hey guys, Just looking for a quick bit of help. Looking to use averageif for two conditions. Normally I'd use the averageifs formula, but, it's not two conditions on one value it's one value where it can be A or B. I've even tried the OR function with no success... So, what I've tried to do...
    • fable
    • Thread
    • averageif function averages countif function or function sumif function
    • Replies: 12
    • Forum: Excel Questions

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
Back
Top