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

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