Get instant live expert help on I need help with excel average ignore 0
“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
I need a formula to use in my average margin analysis. Every column I analyze has some zeros in cells. I want to get the column average but ignore the zeros'
Solved by G. H. in 12 mins
Hi I need a formula to work out the average of some data whilst being able to filter by customer and ignore zeros.
Cell range - R2:R4000
Many thanks
Solved by X. F. in 29 mins
=IF(O3:O347>0,IF(F3>G4,"YES","NO"),"NO")
I want to express this as a percentage but want to ignore the original No count
Solved by X. H. in 30 mins
How do I compute the sum or an average of a column with 5000+ rows when some of the cells have #N/A N/A values? I would like any function (average for instance) to ignore those lines. Can you please help?
Solved by G. B. in 19 mins
How can I get this formula to ignore empty cells and still give me the output I desire?
=AVERAGE(DATE(((YEAR(C2))+1),MONTH(C2:E2),DAY(C2:E2)))
see spreadsheet for more info.
Solved by G. C. in 27 mins