average

  1. M

    Drag Average Formula Vertically, But Reference Increasing Columns

    I am trying to figure out a way to drag my formulas vertically, but have them increase their reference by one column. For instance, the first image shows the main table where the formulas would be located (summary). Group A's data is in the second figure. I would like to average all the values...
  2. C

    take every 4 rows to average them and this average data put into 4 rows as a specific single result

    Hi, like title says i need to take every 4 rows to average them and this average data put into 4 rows as a specific single result. I tried my formula in tab.1 but didnt work. My data needs to looks like tab2. Btw table2 continues to 175 000 rows.Can someone help me what i doing wrong? Thanks for...
  3. L

    calculate monthly averages

    Hi, I have data arranged data table how do I calculate the averages of C,D,E and F and tabulate it by year and month as in the Average China Prices table? Thanks for you help BCDEFGHIJKLMNOP3PO Spot Market Price (unit: RMB/mt)Average China PO prices RMB/ton SCI4DateShandongNorth ChinaEast...
  4. P

    Editing of separate Table, which determines Value in originally selected cell

    Hello everyone! I want to apologize in advance if my language is not the most correct or if I am unable to explain what I wish to do in the best way, as I am a beginner at using Excel. I have attempted many google searches using different wording but unfortunately without success. Here is a...
  5. R

    Count average grounds of a selection of towns

    Hi all, Hope you can help me with the following issue. I want to calculate the average number of grounds in a selection of cities (E2:E4). In this example, the number of grounds per city are given in column C. However, I don't succeed in getting the correct number, because it takes into...
  6. M

    Average non-adjacent cells (with criteria)

    Hi, I am stuck on creating a formula for the below and would be really grateful for some assistance: The table has 4 columns. Column A is text e.g. Apples, Bananas etc. Columns B,C,D are currency. More than one row in column A will contain Apples. I want to find all rows which state Apple...
  7. H

    Vlookup and Weighted Averages

    Need some help here! Two part question here possibly. I am not very efficient with excel yet so please bear with me! I hope the sample file link works, if not I attached an image where I combined sheet 1 and 2 into one to show an idea of what I am working with. SAMPLE FILE 1. I need to find...
  8. A

    Calculate the average of a column with time excluding rows with values in other columns

    I'm trying to calculate the average in column (T) with time on it (00:00:00), and exclude the rows with blank cells on column "E" and the text "PC" on column "R". This is what I've tried so far: Dim ws As Worksheet Set ws = Worksheets("mapa_cargas") Dim lastRow As Long...
  9. A

    Excel VBA - Calculate average in column excluding rows on different columns

    Hello, Can someone help me to create a code to calculate the average on column T exlcuding the rows that are blank on column E and with "PC" on column R? Thank you
  10. A

    nesting within AVERAGEIF

    I'm trying to take an average of the "Average" column depending on what the month in the "Date" column is. Date Trial 1 Trial 2 Trial 3 Average 1/12/2023 100 101 102 =mean(B2:D2) = 101 1/13/2023 103 104 105 =mean(B3:D3) = 103 2/12/2023 106 107 108 =mean(B4:D4) = 105 I'm trying...
  11. S

    Dynamic Average of top values in specific ranges

    Hi everyone. Im trying to find the average of the top values of several- non continued ranges. see image for reference: What I need is being able to average the TOP value of range B4:B15 with the TOP (the ones in green) value of B17:28 and so on for the next following cells that are not in...
  12. F

    Calculating averages in a pivot table using distinct count

    Hi, I am trying to calculate averages per site requiring use of the distinct count function. I've used the following calculations to determine these averages: - Total count (calculated using the sum total) - Column 2 - Survey count (calculated using distinct count) - Column 3 - Average count...
  13. Kobi Merrikin

    Average 2 Columns Pivot Table

    Hi All, I have a pivot table aggregating quarterly data of number of employees at multiple sites. In order to analyse this, I need to know the average number of employees in each quarter to use in an injury rate calculation. I am trying to use a calculated column in the pivot table but this...
  14. B

    Average sum of day

    Hi, I have a job sheet that enters the totals of a day. I need to average jobs completed each day for tracking. so sum each Tuesday and average against each other Tuesday. I have used the averageifs function but that is averaging the jobs within that day. This is the results page, with the...
  15. W

    Best way to calculate multiple averages? (See sample mini-sheet)

    BCD2Average3Apples654Apples625Apples1647.76Oranges177Oranges6139.08Peaches179Peaches7210Peaches2411Peaches6243.812Tomatoes9696.0D5D5=AVERAGE(C3:C5)D7D7=AVERAGE(C6:C7)D11D11=AVERAGE(C8:C11)D12D12=AVERAGE(C12) I have a similar spreadsheet to the one above, containing several thousand rows of data...
  16. D

    Average time between dates *But ignore if blank in either cell

    Version: Excel Online I want an average of the time (in days) between two milestones for many different people (one person per row), but I want the formula to ignore that row if there isn't a date in BOTH date cells, since it throws off the average in a major way. Example "TABLE_1" EE Name...
  17. D

    Calculate Factors to Achieve Goal

    I'm having a challenge in resolving an algebraic problem using excel and would really appreciate some help. Scenario: Call center has goal of answering 80% of calls offered within X time Sum of calls currently answered at goal is 369 Forecast remaining calls in day is 1854 Objective: How...
  18. riverspree16

    Return multiple values from another sheet, based on a single criterion in the original sheet

    I feel like I'm going around in circles between index and more. I have multiple sheets, but for this example just set up the two I needed as they would appear in my workbook. I am trying to make it so that if I select a student's name from a drop down in Column A on sheet 'Student Report' (first...
  19. L

    Formula to Determine Average Hours Worked per Month for People on My Team

    Hi there. I've spent way too much time on this and am probably overthinking it. I've got raw data with individual employee time entries. Multiple entries per employee per day. Employees on my team plus employees on other teams are included. There's a column that indicates the team. What I'm...
  20. L

    Formula for average to exclude cells with no number/text?

    Hello, I have a formula to average a range of cells (ex. =AVERAGE(E2:AG2)) but some of the cells in that range do not have any data and just have a dash "-" to represent that it's not left unintentionally blank, but that we just don't have a data point for that cell. This is done across 300+rows...

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