averageif

  1. D

    Help with Averageif and Percentile

    Bare with me on explaning this. Trying to figure out how to combine averageif and percentile with certain criteria. Id like to average the numbers only in the 90th percentile, for that certain name, based on a names column, where the same names occur more then once. Ive tried...
  2. I

    AVERAGEIFS formula adjustment to replace a number within the range

    Currently I am using a formula to calculate the last 7 days average to then use that average to project data as a run rate for the remaining days of the month. My current method is hindered due to if there is a slowdown in business (ie. Holiday, shutdown, etc.) the run rate will skew heavily...
  3. S

    Using VBA in other language excel file

    I am making an add-in and my excel has english settings, but my colleague has dutch settings in his excel. This is mostly not a problem, except for some worksheetfunctions I use: rounddown, min, max, averageif. Does any of you have a solution how to deal with this? Or are there any good...
  4. B

    Creating Countifs and Averageif Functions in VBA

    I need help creating a few VBA functions in Excel: First I need to write a function (myCountIfs) that works similar to Excel's in built COUNTIFS function. It returns an integer. The first is a range that will be used in the calculation (i.e., average) The first is the 1st range that will be...
  5. B

    Averageif alternative

    Hi, I have an evaluation dashboard which contains graph overviews which change dependent upon what option is selected on a data validation list. The data source is on another tab and it uses averageif against the different criteria I've set to pull specific data from the raw data (eval...
  6. J

    What's wrong with my Average IF formula?

    hi everyone, I wonder if you can help me with a question I have; I want to use the word in Column A to search another sheet - every time it finds a particular word in a sentence (column B) it uses the OR figure in the cells next to the sentence (column C) and calculates an average for those...
  7. K

    AverageIF with OR conditional

    Hello, I've been trying to research a way to include the OR conditional, or an array, within an AVERAGEIF formula, and cannot find a way to do so. The AVERAGEIFS function is essentially an AND operator, so it says that all the conditions must be met, but I need for it to calculate the average...
  8. M

    Average If using Dates

    I have a formula =AVERAGEIFS(J:J,H:H,">=3/1/2018") - where H is a date and J is number, so I am taking an average of everything that is greater than a date. What I WOULD LIKE TO DO is substitute the date with cell location, like in another part of the spreadsheet, so that I can list every month...
  9. D

    Averageifs

    Hi All I am looking for help building an averageifs formula. The formula needs to average between 2 dates which will be across the top of the data, and take in to account a third variable which will be to the left of the formula. This is the formula that I currently have...
  10. E

    Issue with AVERAGEIFS function

    I have weather data for a year that I am trying to average based on the hour. My averageifs function keeps giving me a #DIV/0! error and I can't figure out why. Any help is appreciated. Equation: =AVERAGEIFS($C$2:$C$11085,$I$2:$I$11085,"="&R2,$K$2:$K$11085,"<="&S1,$K$2:$K$11085,">"&R1)...
  11. P

    Excel average/averageif question

    Hi, I've setup an excel spreadsheet to keep track of my bowling league. I'm tracking 3 games for each bowler across various worksheets and calculating handicap and average. The average and handicap are tracked in one cell each for each bowler, not across each different week. On occasion, a...
  12. M

    AVERAGEIF #DIV/0! error

    Hi there, I've searched everywhere for help on this formula and haven't had any luck. Basically, I'm looking in a separate tab for every time a name appears, then averaging all the data in Column BG. What i need to figure out is how to eliminate errors like Div0, #Value ,0 etc. WK1A:A...
  13. K

    AVERAGE using multiple criteria from multiple columns

    Hello I need to calculate the average value of a column contain temperature values (column H). The difficult part is that I want to average only specific cells of this column, that meet certain criteria. More specifically, I want to average temperature values from column H, only if the wind...
  14. C

    AVERAGEIFS function - ignore blanks and add qualifying "if" statement

    I have this formula that works to be a nonblank average of a column J that matches to a specific answer in column B (A21). Column B has non-numerical values and Column J is the data I'm averaging. =AVERAGEIF(B3:B20,A3,J3:J20) When I try to expand this to eliminate "0's" from the averages, it...
  15. N

    Averageif ignoring zeros/blanks not working

    Hello, I’m trying to use the averageif function to find the average of individual cells as a total, ignoring blank cells, but include zeros. At the moment, I have this =averageif(e9,k9,q9,w9,ac9,ai9,”<>0”) However, the cells ac9 and ai9 don’t get selected and I don’t know why? Any help?
  16. R

    Help Understanding AVERAGEIF

    I'm trying to pull an average on Sheet 2 from columns C:F on Sheet1 based on a match in column A on Sheet 1 and column B on Sheet 2. I thought this should be a simple AVERAGEIF formula. I entered the formula as follows: =AVERAGEIF('Sheet1'!A:A,'Sheet2'!B:B,'Sheet1'!C:F) However, I am not...
  17. M

    Averageif with 2 criterias VBA

    Hi, So I have 2 columms, columm A that is in days and hours (2017-01-01 00:00, for example is my first data in the day in cell "A2") and columm B that represent Temperature on that given time. I want to find the average temperature between 6am and 6pm and give the answer in a cell. Dim i...
  18. J

    Average If - Different Cells

    Hi all, I am trying to average 2 cells (k35 and m35) if the cell value is greater than 0. Those 2 cells are an average of the column. I want the equation to average both cells if there is a value in the cells, if not, just display one or the other cell value. The issue that I am running into...
  19. K

    Averageif help

    Hi im reposting this question because i think adding responses to my own question caused others to ignore it. im trying to do an averageif based on if the range contains a certain word, here is how I tried it =AVERAGEIF(D2:D892, "*"&LEFT(D2:D892,(FIND(",",D2:D892,1)-1))&"*", B2:B892) But the...
  20. K

    Averageif help

    Hi, so im trying to do an averageif based on if the range contains a certain word, here is how I tried it =AVERAGEIF(D2:D892, "*"&LEFT(D2:D892,(FIND(",",D2:D892,1)-1))&"*", B2:B892) But the word it picks is the word on the same row in column D, so if i move the cell up to 5 for example, it...

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