1. M

    Calculating Average only if the difference between the values is less than 10%

    Hi, As per title, I'm calculating the average of unique ID's in my list via: =AVERAGEIF($A$2:$A$110, A2, $B$2:$B$110) ID: Value Average Example1 10 10.75 Example1 15 10.75 Example1 12 10.75 Example2 59 54.66667 Example2 60 54.66667 Example3 100 100 4Example 500 505 4Example...
  2. G

    Summarising data help (with pictures)

    I'm stuck on the best way to summarize date. I have 30+ Techs, they each have their own workbook set out as per, "User Workbook Example" Each tech may do a different job each day.. they may do the same, however in there workbook the jobs are laid out as tabs at the bottom. My Example here is...
  3. G

    Average if

    In my data set each line has a persons name, there are a total of 5 names. After their name is a start time and date and after that is a Finnish time and date. This is laid out from column a to c each name has multiple entry’s in the data set anywhere from 20 to 70 entry’s each day. is there a...
  4. O

    Sum Monthly Data to Quarterly

    Trying to Sum monthly data from a column in a different sheet to a quarterly output in a row on my summary page. Anybody know of a formula that I could use to do this? Thanks!
  5. G

    running average based off month

    Hello, I have a table that I want to keep a running average off of based on month. The table looks like this: <tbody> Month Score 1 0.92 2 0.92 3 0.89 4 0.91 5 0.91 6 0.81 7 0.88 8 0.89 9 0.83 10 0.86 11 0.94 12 0.93 </tbody> I want to keep a running average from...
  6. D

    Linking data from another workbook using AVERAGEIF

    Hi everyone, I am using an averageif equation, and in the equation I am referencing data from another workbook on my company's server. When I have said workbook open, the equation works and I get my number. However, if I close it, I get a #value ! error. Is there anyway to fix this error and...
  7. I

    Averageif specific cells rather than a range

    I am trying to create an averageif formula but rather than for a range, a specific set of cells: A1, A5, A7 I thought it would be as follows: =averageif((A1, A5, A7), "<>")) But this returns #Value! Any advice or help would be much appriciated. Iain.
  8. A

    AverageIF issue

    Hello, I am having a hard time figuring out this formula, any help is appreciated. I would like get an average of seconds based on certain criteria. For example, if using the table below, how could i get the average of seconds below 1:00? <tbody> 00:25 1:02 00:26 1:22 00:80 00:30 00:29...
  9. K

    Average If (I think) Help

    Hey guys, Long time lurker, first time poster! Need some help if I may, I'm running a dataset for tender airfreight costs for my business, got the results split by country of origin, by weight break (45kg,100kg etc), across 4 carriers and three service levels (Deferred/Standard and Premium) I...
  10. R

    Averageifs with multiple criteria

    The formula listed below is only averaging items for "5B" and does not include items from "LI". I have tried everything I know to get it to produce the desired results. Any ideas? =IFERROR(AVERAGEIFS('WORK ORDERS APPROVED DATA'!$N$7:$N$3500,'WORK ORDERS APPROVED DATA'!$G$7:$G$3500,P11,'WORK...
  11. D

    Calculated Average by Fee Level

    Hello - I'm trying to calculate a measure where I can see the average number of hours by fee level based on the 'individual'. As an example based on the data below, the average for Person A would be 4 within the 20K fee level. <colgroup><col><col><col span="5"></colgroup><tbody> Fee...
  12. P

    Averageif Too many arguments

    Hi all, I'm new to posting here an not much of a wizard with Excel formulas, so was hoping someone would be able to help please. I'm trying to calculate an average percentage from another workbook, for anything that's 8% or higher. Here is my formula =AVERAGEIF('[Sample...
  13. S

    Average if Error

    Hello, Why am i getting #DIV/0! ??? =AVERAGEIFS($C$3:$C$40929,$B$3:$B$40929,$E3,$D$3:$D$40929,F$2) <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> 1 A B C D E F G H I J K L 2 Monday Tuesday Wednesday Thursday Friday Saturday Sunday Date...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

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