Get instant live Excel expert help with MAX Function

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

I am trying to place a band into a chart, the min is 4 and the max is 10. when the band appears on the graph the min is 4 and the max 14? why cant i have the band reflect the 10 that i need to be represented in the graph

Hello, i have a column with several numbers. In a second column, i want the total of the first column, but only until the biggest number in the first column. Imagine, the numbers are from B1:B8. In the second column, i wanted to use "=Sum(B2:Max(B2:B8))"...but it doesnt work. Can you help me

I need a formulas using only this functions , Mod IF and or round roundup sqrt min max sin cos to figure out how many hrs does a take to do a job Example. 10 to 20k 30 hrs 20001 to 30 k 60 hrs and so on increments of 10 k increments of 30 hrs

Column C contains numbers only from rows 9 to 21. These could be either whole numbers - 1, 2, 3 etc or decimal numbers 3.5, 4.2 or 5.0. Minimum is 1 max is 5. If a cell C9 - C21 does not have a number then Cell H21 to insert 'ERROR' and conditional format cell to warning colour - red.

I got the following formula in my latest session: =_xlfn.MAXIFS(Q:Q;C:C;C2) But Excel 2016 does not have the maxifs function anymore, I need some help with changing to MAX(IF(

I am trying to set up a spreed sheet in excel to automate cutting lits generation . but i can not work out how to find, a formula to return how many results i have between set figures. I.e. if the min is 1000mm and max is 1500mm how can i find out all numbers between them ?

I need a formula to nest letter grades based on a grading system of percentages with A being above 90% of the max score of 80, B above 80%, C above 70%, and an F below 70%

I have two separate MAX formulas in cells M19/M20.# i wish to have both formulas in a MAX fuction in M19.

I need help with a formula. Data: Extra person charge : 800 Max of 4 people in 1 room Only have extra charge if there is a 3rd and/or 4th person in the room Eg. 1 room, 3 adults = 800 extra person charge 2 rooms, 5 adults = 800 extra person charge 2 rooms, 7 adults = 2400 extra person charge I need help with making a formula to satisfy all the requirements so Ill be able to monitor the total income from each booking