Questions tagged [average]
The average tag has no usage guidance.
31
questions
0
votes
2
answers
83
views
Calculate a moving average in excel where the lookback (window) duration is a variable that changes based on another cell's changing values
I am trying to calculate a moving average of a dataset where the moving window time duration is not fixed, but changes over time based on numbers in a different column. Using the screenshot I have ...
0
votes
1
answer
497
views
Ignore blank/0 values in AVERAGEIF with two ranges
Trying to calculate average waiting time but, need to ignore blank or 0 value cells.
For example, here i'm calculating time difference between H column and G column and getting the average. However, ...
0
votes
0
answers
119
views
Averaging film transfer from 59.94fps to 24fps using ffmpeg?
I have some video files which were transferred from black-and-white film to 29.97 fps interlaced. The film was transferred too darkly (meaning that it requires some brightening), and it also has some ...
0
votes
1
answer
163
views
Excel formula for calculating average of 52 cells out of possible 104 where blank cells exist
I have a significant amount of rows of data showing earnings per week for over 104 weeks with various blank cells.
I am looking for a formula that would average only the latest 52 cells that have ...
0
votes
2
answers
9k
views
Excel: How to calculate average difference between values in a row?
I have a row of numbers, say, 1 2 3 (each number is in separate column, of course). I want to calculate the average difference between all values. This means that I would calculate all the differences:...
0
votes
1
answer
32
views
How can I complete a column with a function with a key of another column
I'm trying to calculate a weighted average for thousands of students.
I can do this for individual learners in turn (SUM PRODUCTS).
The problem is I don't know how to do this for thousands of students ...
0
votes
2
answers
818
views
Excel: How can I get the most recent 3-month average, but not use blank months?
Hi people better at Excel than me! I appreciate any help you can offer. I’ll try to be brief:
I have a 3-column table. Month (as 1,2,3,etc…), Salesperson Name, and Sales. Each row is how many $ in ...
0
votes
2
answers
187
views
How to find average with my condition in Excel?
Let's say that this is my bank statement for July 2020:
Sl. No.
Tran Date
Withdrawal
Deposit
Balance Amount
1
01-07-2020
100
100
2
02-07-2020
5
95
3
03-07-2020
500
595
4
06-07-2020
50
545
5
...
0
votes
1
answer
166
views
How to Calculate the Average after a certain date
Im trying to get the average of days taken to send to college but i only want it to take in to consideration dates received after 17/05/2021.
can anyone help
1
vote
1
answer
47
views
Excel/Sheets: Average only the input data in a range of data?
I've got an annual budgeting spreadsheet in which each month is listed along with given categories of items. I'm trying to find my average monthly expenditure on any given category, but don't know the ...
2
votes
3
answers
941
views
Average of rows averages does not equal average of whole table
I am averaging a group of numbers in Excel 2007 that have 21 columns & 42 rows. When I average all the cells at once I get one result, 59.25183, but when I average each row & then average ...
2
votes
0
answers
980
views
How to calculate average number of days, hours and minutes in excel
Can anyone help me please to calculate the average number of days, hours and minutes in excel? It is to calculate the average time taken to complete maintenance jobs.
To start I merged the date and ...
0
votes
1
answer
333
views
Finding average between two dynamic range
I have to find the average of a column B by giving a dynamic range for column A.
I want to calculate the average by changing ranges from D2 & E2.
Is there any way of achieving this?
0
votes
1
answer
329
views
Pivot table averge by total number of months
I have an excel data table which have these colomns,
Purchae date
Item name
Quantity
Sipplier name
Now i want to get average of quantity by total number of months.
I.e quanty sum is 50 and this is ...
0
votes
1
answer
5k
views
Excel: Averaging 2 columns with a PivotTable
Data example:
Year
Activity
L
H
2019
x
5
9
2015
z
1
0
2015
x
5
4
2020
z
4
5
2020
y
7
3
Using a pivot table, I can average L by "Activity" and average by "Activity" looks ...