Get instant live Excel expert help with AVERAGE Function

I have a problem regarding to How to Caculate a Rolling Average in Excel

Hi Team, I have table which include data sales for specific period, I want formula to find the average sales of last 5 DOW, I mean, as today Friday 02nd Nov, 2018, I want the Average sales for the last 5 Fridays for each market segment, I have the excel sheet. Thank you Murad

I want to find the average of the numbers in column I if column A is 3 and the value of column B is 3. This is the formula that's in there, but it says there are is an error. Can you help? =AVERAGEIFS(A12:A1000,"3",B12:B1000,"1",I8:I1006)

Solve an average size - want to look at name on tab QScorecard B3, then look at the data tab - needs to sumifs ( new/existing business) column C, and Column D = Closed won and return ($$$$) then also countifs same criteria but solve ($$$$)/ count to give us the Average size

I need to know how many suppliers( in a row can be repetitive) are there who has equal or greater than the average cost ( another row)

Hi! I need to calculate the average elapsed time for the conversations that are bordered in column D

I need help with an average formula for a report

I need a formula to conditionally format a range. The values in the range that need to be formatted, must be more than 5% greater than the average of the range. The range is $G$2:$G$11 I don't know how to represent the greater than 5% with the average of the range and what operator to place in between. Thank You

Hi, I have over 100 columns and 11,000 rows with numeric data in - however, amongst the data there are missing values which hold the value '*'. I want to remove all of the '*' values with the average of the column o which it belongs. Any help would be really appreciated, as manually replacing these values with the average will take far too long! Thanks a lot.

I have a set of 4 scores. How to find averages of the 3 highest scores. what formula do I use?