I'm trying to sort column G for any "Approved" or "Denied" outcomes then find the time difference between columns E and F then divide that difference by the number of approved or denied in column G. I've tried a number of combinations of SUMIFS, IFS, COUNTIFS, and Ave formulas but can't come up with one that works. Here's an example of what I'm trying to do:
Sum E-F if G= "Approved" or "Denied" / the number of "Approved" or "Denied" outc
I'm trying to determine the average of a set of numbers, based on a scale of 1 through 10. There are two columns and it would look something like this:
1 3,452 2 2,990 3 564 4 etc.
I want to determine the STDEV here as well but assume I can just exchange the AVG function with that function, once I know how to tie column B (the numbers) to column A (the rank).
Refer to the attachment. I am trying to average the data in the Y column, if the times fall into the range between column R and S. I am having trouble with the averageif function. Is there a better way to parse through column W, check if the values fall between the ranges of S and R, and if they do, average the associated values in column Y?
I am having a little trouble with a spreadsheet I am creating, the formulas and cell formatting I should be using to enable this to work.
Here goes:
in cell E3 I have a time started (e.g 12:45 pm), In F3 i have time finished (e.g 2:30 pm)
So, what i'm wanting is the time taken in G3 and also, i have the amount of units that is entered manually in H3. I would like I3 to show the time taken per unit.
I am trying to create a spreadsheet to determine hrs per time interval
i.e 06:00 - 14:00 14:00 - 22:00 22:00 - 06:00
So a start time of 06:00 and finish time of 14:00 would show 8hrs in first interval and 0 in the other 2 and a start time of 10:00 and a finish time of 18:00 would show 4hrs in first interval and 6 in second and 0 in last
I've currently got start time in A1 , finish time in B1 and want hours for interval 1 in D1 , interval 2 in E1 and interval 3 in F1.
I am trying to determine a formula to know a period time for example i started to test a unit at 10:20 am of 10/02/2011 and i would like to add 52 hours of test and i would like to know when and at what time will finish the test?
I'm trying to calculate when a waiting time falls outside and exceptable time period. This is based on two colums of data. The first column contains a number from 1 to 5 and the second a time period. (see attached example) in column "C" I need a formula that looks at the value in "A" and if it equals (1) and the time period in "B" is > 00:02 it should show "EXCEEDED". If "A" does contain a (1) then the code stops otherwise it does another loop of "A" looking for a (2) and a time in "B" of >00:10 etc.
I have found an older thread that explains how to determine if a date falls in DST or not. See here Daylight Savings Time Funcitions. It does not follow the DST rules we use here in Canada and the formula is very confusing to me as it uses arrays, something I have yet to fully understand. DST in Canada begins the 2nd Sunday of March and ends on the 1st Sunday in November. I have a date in one column and a time in the next. What I would like to do is have a formula that checks to see if the date falls in DST and if so adds 1 hour to the second column. The result will show up in a third column.
I am trying to determine for each account number in column A, the most popular method for accessing our services based on visits in column B. And then having those numbers summarized as a total for each method.
See below for an example. As you can see Mobile was the most popular for 2 clients Java was for 1 and Desktop was not for anyone. Not all accounts will use all methods.
I have actual date , then I have names of customer and I have product reference. And what I want to find out is the latest price COLUMN D for which this specific product was sold to specific customer (Data in rows E,F,G,H are from another tab). So basically I want is to find out that latest price of product x27 sold to customer A on 15.7.2013 was 70 because on 12.7.2013 we have sold it to customer A for 70.
How to create a formula to determine the longer period of time between two date calculations and enter the longer period of time in the cell.
My Spreadsheet: Cell M2: Birthdate (entered in cell as 11/1/2004) Cell J2: Last date of service (entered in cell as 10/31/2011) Cell G2: Calculation to enter the longer period of time between (M2 (year) + 21) and (J2 (year) + 7)
Example using information from above: 2004 + 21 = 2025 2011 + 7 = 2018 2025 is the result I want added to G2
If there is any way to include the month/year in G2 that would be ideal.
how to find the average times of two different sets of groups. There are the baseline times and intervention times. Both groups have three subtopics: Time Fell Asleep, Woke Up, and Duration (how many hours I slept). I am not sure how to find the average of each subtopic. Here are the times....
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim rng As Range Set rng = ActiveCell.CurrentRegion Application.StatusBar = _ "Current SUM is: " & _ Application.WorksheetFunction.Sum(rng) & " " & _ "Current AVERAGE is: " & _ Application.WorksheetFunction.Average(rng) End Sub
I now have the following problems:
I get a errot when i select cells with no number
Run-time error 1004 Unable to get Average property of the WorksheetFunction class
The sum and average stay in the status bar.
The code gets confused after i selected different columns.
I would like the code to work only when i select a range of cells.
Is it possible to move the text in the status bar more to the right?
I need to find the average time it takes students to take exams . I use the following formula =text(end time - start time, "h:mm"). I am able to calculate the amount of time it takes a student to take the exam. Now I need a formula to calculate the average time students take to complete a test. I have over 80 times i need to average. Whenever i try a formula I keep getting 0.
I need get an average call time. I have column C that is the time call started and column D is time call ended. What would I need to get the average call time for the entire sheet? I'll attach a copy of my spreadsheet for you to look at.
I have some data, consisting of two columns. The 1st column consists of time values in the form hh:mm:ss, and the 2nd column consists of a pressure reading, taken every couple of seconds. I wish to find the average pressure from the start time, to a 2nd time, then the average pressure from this 2nd time to a 3rd time, then the the av. pres. from this 3rd time to a 4th time, and so on. The time i want to take the average over varies, sometimes 3 minutes (i.e. ~180 pressure readings), sometimes 4, sometimes 5 minutes. I have to take the average over different ranges dozens of times -
In the above I am looking for the average of Title1, where the value is greater than 0. There are 3 occurances of Title1, but only 2 have values. The answer i am after is Sum is 8, average is 4 (ie 8/2 and not 8/3)
Ceate a formula for weighted averages according to criteria?
I want to know what was the average price I bought a product at on today's date. The average price needs to be weighted against the quantity of product sold.
I have information I'm trying to evaluate. Average Close time. but I need to evaluate it for each month. Forinstance if my average close time was B. and the close date was c. I would need the average(b:b) but only from fields that had a close date of July in column C. is this possible? I hate to have to break up the data set 12 times. (i'm reporting individually for each month of the year so we can see trends.)
In column A is the staff name, column B is the start date, column C is the end date and column D is the difference.
I need to find the average number days for task completed for each staff for the week. I need a formula that will look for a particular staff name in column A ( which appears many time randomly in column A for each day of the week) and calculate the average days for the total task completed for the week.
i have a excel spreadsheet that contains point of person. Every week a person can or can not compete. That means that there is some days that is blank wouthout points. I want to get the latest 5 points of a person and then out of that 5 i want to get the top 3 point.
I have trouble finding the right formula for a weighted average price. The formula which i used in cell B2 of the attached file doesn't exclude irrelevant numbers. In the formula "= sumproduct(a5:a21;b5:b21)/sum(b5:b21)", i like to exclude cells B8, B9, B15, B19, B20 because the list prices are missing. How can i exclude these irrelevancies in the formula above?
