Get instant live expert help on average value formula

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Why is my average value for my total hours/day column showing the wrong value. I used the average formula to take the average off all the rows.
Solved by M. H. in 30 mins
I need a formula to average skipping cells with greater than 0 value. Formula: averageif(range,[average_range])
Solved by X. A. in 13 mins
Hi! I need a formula that calculates average value from one column when other column contains one of the text values "A", "B" or "C"
Solved by M. Y. in 20 mins
I need a formula to find the average of two cells if both cell values are greater than 0. If one cell value is 0, no average is needed. Example: A1 = 50, B1 = 50, C1 = 25 A1 = 50, B1 = 0, C1 = 50
Solved by E. F. in 16 mins
i would like to use vlookup to output an average value based on 8 values
Solved by F. H. in 15 mins