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!”
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