“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

Solved by G. E. in 29 mins

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

Solved by G. J. in 11 mins

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)

Solved by M. H. in 25 mins

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

Solved by F. E. in 11 mins

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)

Solved by M. J. in 29 mins

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

Solved by Z. H. in 26 mins

I need help with an average formula for a report

Solved by X. D. in 14 mins

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

Solved by D. F. in 21 mins

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.

Solved by S. B. in 19 mins

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

Solved by S. D. in 30 mins