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

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

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