Super User Stack Exchange
Super User Stack Exchange

Questions tagged [average]

30 questions
3
votes
2 answers

Find the AVERAGE amount that an employee stays with company

I'm trying to find the average time that an employee is employed with my company. Right now I have calculated the time for each terminated person individually and have it displayed as years, months, and Days. I'd like to add all of the time and…
Kandra Gervais
  • 31
  • 1
2
votes
3 answers

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 those results I get an entirely different result, 72.791.…
James
  • 21
  • 1
2
votes
0 answers

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 time cells for both start of the job and the end of…
Rachel Hayward
  • 21
  • 1
1
vote
1 answer

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 function for an average of only the months that…
BudgetingInNeed
  • 13
  • 3
1
vote
1 answer

Excel formula to average out numbers based on repetitive values

I have been trying to average out values in column 1 into the values as mentioned in column 2. For example if: there are 10 12100 values, so individual average is 1210 There are 5 4550 values, so average is 910 I have used the formula…
Sheenam
  • 11
  • 3
1
vote
1 answer

How can I stop AVERAGEIF formula returning #DIV/0

I have the following formula returning #DIV/0! when all 5 cells are blank: =AVERAGEIF(CV17:CV21,">0") Spreadsheet image This is being used to average call time over the period of a 5 day working week so I am using the AVERAGEIF function to only…
Ben Nicholas
  • 15
  • 1
  • 6
1
vote
2 answers

How to find the average time from an array in PowerShell

I am referencing a list which has a lot of data in the form of the elapsed time of a process and I'm trying to convert it to a format where I can find the average amount of elapsed time. The data looks something like this: ElapsedTime 0 hours, 1…
cyborgcommando0
  • 833
  • 2
  • 14
  • 27
0
votes
0 answers

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 dull off-color artifacts. I was able to adjust…
The Poodle Bites
  • 1
0
votes
1 answer

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 earnings in them.
user1799718
  • 1
0
votes
0 answers

Excel Pivot Table with blanks?

i have a problem. i have alot of data. the data consists of each item in each other over a period of time. so the data looks something like this: customer1, ordernr, item1, amount customer1, ordernr, item2, amount customer2, ordernr, item1,…
Hui Mei
  • 1
  • 1
0
votes
2 answers

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: 1-2=-1, 1-3=-2 and 2-3=-1, and after that I…
user1718526
  • 1
  • 1
  • 2
0
votes
1 answer

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 at the same time. Each student has a different…
QarRaQ
  • 1
  • 1
0
votes
2 answers

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 sales a salesperson got for that month. It’s…
Boswser
  • 3
  • 1
0
votes
2 answers

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…
Random Person
  • 403
  • 1
  • 5
  • 15
0
votes
1 answer

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
Stephanie Young
  • 1
  • 2
1
2