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
Solved by X. F. in 29 mins
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?
see spreadsheet for more info.