Get instant live expert help on I need help with excel average exclude 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 am trying to average cells that have zeros in them and I want to exclude the zeros in the average. I have tried the Averageif(B2:b13,"<>0") but it won't work? Any ideas?
Solved by E. U. in 11 mins
vba to save all sheet in a workbook to csv with range and exclude value 0
Solved by S. B. in 12 mins
in Excel 2003 I would like to format cell with different color number but to exclude number zero. For example : red <8, blue >8, black 8 and 0. I type [red][<8]0;[blue][>8]0;[black]0 but in this case zero also turn red. Thank you
Solved by D. Q. in 11 mins
I'm attempting to write a formula that would average the last 3 invoices of a Customer. However, I would like to exclude any major outliers from the average. For example, if one of the past 3 invoices is 50% greater than the other 2, leave the outlier out of the average.
Solved by I. B. in 27 mins
I need help with a dynamic average formula that will always include newly added columns. But exclude the last 6 columns in the row. This formula will be used for the Visit Average per week.
Solved by I. B. in 21 mins