# average

1. ### Use AVERAGEIFS based on dynamic criteria

I'm trying to average a set of cells based on multiple criteria (hence the AVERAGEIFS), but I want this average to change as more data is added. There may be a very simple fix for this, but I can't figure it out for the life of me. Below is a sample of the table followed by an explanation of...
2. ### averaging months

what i want to do is. i want a foumula that will let me to get a rolling average for a month as i add numbers for each week. that total will be in one cell. I want it to be able for it to figure a average for week 1,2,3,4 so that I will have a current average each week. Example: week 1...
3. ### Average days by type and year

<tbody> Type Days Year 34 12 2017 34 24 2017 65 11 2017 66 44 2018 34 23 2018 66 13 2018 34 44 2019 65 8 2019 66 31 2019 </tbody> I want the average days by type, by year. So for example, in 2017, the average days for type 34 is 18. The average days for type 65 is 11. I...
4. ### Average of an Average

I suppose this is more of a math question but I also want to know if I am calculating this right in excel / would be getting the correct numbers. I want to get the average turn around time (time between 2 dates) for the last 30 days. My data is as follows: <tbody> Date 1 Date 2 Difference...
5. ### Future employee salary/rasies

I know how do do a simple salary schedule to to calculate year over year salary. I've tried googling, but came up short. Does anyone know of a formula that I can use to calculate year over year salary expense average? I'm trying to create a template to use for new-account bids to factor in...
6. ### average last 5 values

Hello, I want excel to find me the last 5 values so then I can do Average, Min, Max... I found this formula =AVERAGE(OFFSET(C3,COUNT(C:C),0,-5)) from site https://exceljet.net/formula/average-last-5-values </pre> but the problem is my column is full of numbers and I want it to ignore the...
7. ### Pivot Table Calculation for Sub Totals

I have the below pivot table with 2 value columns that I need for any subtotals (in this example Romaine Leaves is the sub total of the 5 rows) to calculate the weighted average of the 5 rows (the math for this is the 3 columns to the right of the pivot table. Instead of 10.9 showing for Average...
8. ### Need to calculate Average of first 5 non-zero cells in a ROW

In this example, each score is entered for only the players that played this week leaving lots of blank cells. A new column is added each week between Column D(Hidden) and E. I did this so the arrays in formulas will automatically update when a column is inserted inside the array. In Column...
9. ### MIN MAX AND AVERAGE - Excluding Zero value

Hi, Wondering if anyone can help please. I need to find the min, average and max values from a column in excel. However, I need to exclude any "0" values, and to save be changing the range I need to also find the average based on a set criteria. So, like an average value in one column, but...
10. ### How to count a number of consecutive cells with 1 in row that is intermittently interrupted with blank

Good day all, My excel skills are very poor. I have a situation where I want compute the average number of times a student attends class consecutively over a period of say a semester. Rows represent individual students and the columns are days. In the cells are either 1 if students attends or...
11. ### 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...
12. ### Using the AVERAGE function with IF.

Hi, I have a lot of data in Column I, which relates to %'s. In Column F, I have data relating to the amount of times a participant took part in a race. I want to do an average of Column I. So normally I'd just put in =AVERAGE(I:I). However, I only want to get an AVERAGE of people who have...
13. ### Help with monthly average

Hello all, after hours spent trying to find a solution online, which was unsuccessful, I decided to post a new thread and see if anyone could help me out. I have multiple pivot tables connected to timeline slicer where user can select time period to view data set. I found online how to get...
14. ### How to get the averages for Minutes

Hello All, So I have the following data, which is mostly in minutes: 00:01 Mins 00:05 Mins 00:04 Mins 00:03 Mins 00:07 Mins 00:04 Mins 02:32 2 Hours 32 Mins (152 Mins) How do I calculate the average of minutes? (based on the data provided) Currently from Format Cells, Number tab, the data...
15. ### Multiple lookup criteria

Hello there. I need help with a lookup matter. My efforts to use INDEX and MATCH have not worked. A system generated report is received is in columns and looks like this: Ticket ID Type Measure Oct 2019 Overall Result 7004114394 Amount...
16. ### Average groups of numbers within a larger group

I have a large group of numbers in a column. I would like to average those numbers in groups of 7. So average the first 7, average the 2nd 7, and so on down the whole list. Is there a way to do this without manually selecting each group to find their average? I have Kutools and ASAP utilities...
17. ### Sumproduct Average

afternoon all. Just chasing some feedback on a sumproduct average style formula I have; Col A - Supplier Col B - Month Col C - Income I'm wanting to average Col C based on certain criteria from A and B i know this isn't it - however similar to. =sumproduct(--(A:A="Supplier...
18. ### Average With Exclude Text,Blank Cell, Zero Number

hi all.. how to make average formula exclude 3 criteria text, blank cell, zero (0) =IF(COUNT(H8:T8);AVERAGE(H8:T8);"") but still not fully working thanks in advance.. .sst
19. ### Average if on dynamic Range

Hello, I have a worksheet that I want to add an average row after each category. I can get the added row but how do write a formula to select the changing ranges for each category? The example shows the original data and what is should look like after the macro runs.Excel...
20. ### vlookup with approximate values

Hi The vlookup = =VLOOKUP(B2,\$H\$2:\$I\$5,2,1) with approximate values is working if the table like this This table start H2:I5 <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> average grade 0 f 50 c 60 b 80 a </tbody>...

### This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...