average

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...

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...

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...

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...

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...

Hello, I have a set of daily numbers (excluding weekends) for every day of every month. At the end of the month, I need to calculate the percentage change from the first day of the month to the last day, and also the mid-month percentage change (from the middle day of the month to the last day...

Little bit complicated code I found somewhere here on the forum, but cant seem to re-find. That said, I want to use the very useful SMA function below (written by Bobby if I recall correctly?) and port it to work in the array calculations in vba, not in the sheet. My first hiccup is that it...

Hi everyone, Trying to get the average processing time of coloumn K but I get a #DIV/0! error. Does anyone know what could be wrong? Both coloumns are formatted as TIME values but K is still text when using =ISTEXT. Formula =AVERAGE(K2:K10) I get a #VALUE! error when using this formula...

Hi I am trying to figure out a formula that would give me the average tenure per year of the Active employees for that year. I have a list of the employees with start and end dates and their Departments, and their tenure for each year they worked. Here are the two lists: What I need is to get...

Hi all, Hoping someone can help me with this formula: {=SUMPRODUCT(INDIRECT("'"&"2010_Sold.xlsx"&"'!"&{"January","February","March"}&"["&"Current Price"&"]"))} Which is returning 0 Or, =SUMPRODUCT(SUM(INDIRECT("'"&"2010_Sold.xlsx"&"'!"&{"January","February","March"}&"["&"Current Price"&"]")))...

Hey there Could you please help write a formula to find the average turnover of customers from each country I tried =AVERAGEIF(A2:A91061,A2,B2:B65759) but it shows DIV/0. My goal is to find average turnover for 'LV' etc. Thank you

Hellooo Thanks so much in advance I have employees on column M I have a bunch of different items they worked on on column E I have the time they spent on column K I need a table made in a new sheet, that puts each employee and the average time they spent working on each item. So I guess...

I have a table with 20 rows and only 6 rows have data in them. I'm trying to get the average of only the rows containing data in a column. Can anyone help me figure out why I'm getting an error on this formula? Example: Sam 5 Jess 2 Dean 4 Michael 4

Help please if you can, I cant seem to find anywhere else. Im trying to find the equation for 2 things, 1. I have a chart I'm making and trying to calculate if something is past due 30 days, 10days, and 5 days is there an equation to find out if the dates I entered have passed...

So I have two sheets. One sheet has my employee list with historic Start and End Dates. My other sheet is the summary of that list by Month. For example, lets say I have 10 Employees on my Employee sheet that all have Start and End dates, on my second sheet I have to summarize that info by...

Hey I have 49 cells which represent profits for different quorters, I need to find their average. It is said it should be less than 400000 per quorter. Plus, the 49th cell is blank, I need to find its value without affecting the average. Please help me?

Hi, I have a spreadsheet that I am using to track audits completed. At the bottom, it adds up and has to be in a certain range to turn red/amber/green over the 10 audits. I was wondering how it is best to add a column in to work out if we only did 5 audits, but so that it still fits into the...

Good afternoon; I'm trying to get 2 cells, not side-by-side, to average 2 letter grades in a 3rd cell. All I am getting is a #Spill! error. Also, if I do enter grades into the cells, it subs the value in H4 into K4, which is not helpful as it is not finding the average. In my screenshot, it...

Hello ! i have created a excel for the shares i buy. i want to use formula for AVCO (Average cost method) method. I am attaching file for reference please if some one can help me with the formula. ABCDEFGHI1#DateStatusC.Note #Scrip NameQtyT.RateT.AmountC.O.G20110/09/21Buy9794Sun...

I am currently averaging values in one table based off of their rankings in a separate table. I am doing so for each combination of the potential rankings. The formula below works for this purpose. =AVERAGE(IF((Table2[ranking]=B2)+(Table2[ranking]=C2)+(Table2[ranking]=D2),Table3[Value]))...