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

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