average

Hi, I’m trying to average the total minutes of the first N -- in this case, 3 in lieu of N -- movies watched by a client. Please see my sheet: docs.google.com/spreadsheets/d/1oTwnB5u7y4KqAwamvjsEats3JiTPpYhEkOqUvOzEkDE In column A, you can see the extracted numbers from the minutes texts so...

Hi all, hope things are going well. I am trying to calculate a weighted average using sumproduct but have a little problem: I can't just use normal ranges in the sumproduct and sum formulas. Assume row 1 has my values (in yellow) and row 2 has my weights (in green), then normally I would...

I am creating a gradebook which has users add new evaluations through a VBA userform. Each new evaluation is added to the next empty column in the worksheet. Two of the data entered are the Category and the Points. In the sheet Settings!K2:L17, the Category code (column K) is associated with...

I have a userform that takes input from the user and adds it to the first five rows in the next available column of the worksheet. In row 6, I want a formula like: =IFERROR(AVERAGE(D7:D32),"") but the cell reference, of course, has to be for the current column (which changes with each instance...

Hi all, Hoping for some help with a formula please. I have an averageifs formula that works fine looking for an average with two criteria. My issue is I only want this function to work if a name appears more than 2 times for everything else I just want it to be blank. I have uploaded an...

Using Office 365 on Windows 10, When column A is TRUE, I want to find the Average of column B. I know I use could Filter, but I want to create a formula instead. Can someone help...

Hi there, I want to use avergae function to calculate average from different cells like: (AB14,AB51,AB88,AB125,AB162,AB199) but ignoring 0, #DIV/0!. What formula I have to use to calculate average from different cells? Any help will be very appreciated. Thank you.

Hello, I am calculating a weekly score for number of steps performed. I'm taking the top 5 days out of the 7 days in a week using this: =AVERAGE(LARGE($B$2:$B$8,{1,2,3,4,5})) The NO HOLIDAYS table in my spreadsheet is working perfectly. The HOLIDAYS table is just a copy of that table which...

I have created an example version of the spreadsheet I am attempting to create. Each months sheet looks like what I have posted below. I am looking to use one of these sheets each month. I would then like an analysis tab where I can look at; -Overall Average of "Test Scores" - (I can and have...

I am trying to calculate a rolling 90 day average of results. Each sheet references a month and are titled as followed January '21, February '21 etc. Within each of these sheets I collect scores gathered on a certain date. Column C contains date that result was collected and Column D contains...

Good Afternoon I need help to work out how to show the proportion of days taken per category. I have posted how this looks in Excel however I am struggling to create a Measure in Power BI to replicate it. My data is in one large table, called Sheet 1! The example below: first 2 columns are...

Hello all, I am trying to get an average of values in two non-consecutive columns, and only include values between 80 and 120. In the screenshot below, I would like to average the values in columns I and K together. I also need to exclude any "" cells and cells that may contain #N/A. My full...

Hello to all! I really need your help... I'm currently following an online course about Supply chain planning and here is the issue i'm having, i can't round the average number! I'm doing the exact same things as the teacher is showing and all i get as a result is error. First thing i do is...

Hi All, I am currently doing some Data Entry for work and I am just wondering if there is a more efficient way to do my task. Currently I am gathering total quantities of lumber used on one house, for all our houses, and finding the average lumber quantities for those lots. The trouble I...

Hi , i have a question . How do i find the average for each row? Do i use the =average(number) as in picture 1 and then click on plus or =average(number:number) as in picture 2 and click on plus? I need the data to be in average to run the regression . My professor said that we need to find the...

Good evening everyone!??? I wanted to kindly ask you for a send as I just couldn't find a solution for over a week now .... In the column under the writing (TEST) the formula should be entered, and what I would like to do is calculate the UMCSI values corresponding to <3% and> 2.8% of GDP for...

How do i calculate the average when the data is like this?

Hi, As in a sample sheet enclosed herein the data contains three columns and headers like weeks, location and Gain or Loss, I already worked out for Sum and Average (Column C27:C30) of values gain and loss (unfiltered category) I am looking a formula for Sum and Average (Column C32:C35) of...

Hey, I'm trying to find the average of 1 cell that is linked to another cell. In the image below, I am trying to get the average of the numbers linked to column A - so AAA and BBB. Taking 'AAA' as an example, I first need to find AAA in column B and then take the letters in column C and find...

Hi, I'm having trouble with the average formula in my excel sheet. I'm simply wanting to calculate the average of three cells, however the average function is returning a #Div/0! error as if the cells are empty. I should mention that the values in the cells I'm trying to average are returned...