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

I need to find the high, low and average of every data in every 7th column. I created a new sheet and used formulas to show the numbers but when I use max function etc, it doesn't recognise the numbers that are the answers to formulas. The cell in formatted as number. I need to find max, etc of the formula answer.

Solved by B. U. in 17 mins

I have 5 years worth of data. I want to work out average, max and min for each month over time

Solved by G. A. in 20 mins

I need a formula or function to calculate the average of a series of cells but filtering out the top(MAX) and bottom(MIN) cell quantities

Solved by K. U. in 16 mins

I need to graph a set of date and have an area chart show the range of max and mins and then plot lines graphs on top of this to show average, each year, and standard deviations. For some reason the area graph part of this graph jumps to 0 when the max is below zero. Help!

Solved by A. Q. in 25 mins

is sorting data and filtering Data the same thing? also wmat does this mean? "turn on total row and set in various functions: SUM,COUNT,AVERAGE,MIN,MAX

Solved by A. J. in 18 mins