Search the Q&A Archives

# I am attempting to create a running average in one field: ...

 Question by iankeefe Submitted on 7/10/2003 Related FAQ: comp.apps.spreadsheets FAQ Rating: Not yet rated Rate this question: N/A Worst Weak OK Good Great I am attempting to create a running average in one field:  My example is, I have a column of cells (B4:B25) at the end there is one line totaling all the cells and one line giving an average of all the cells (B4:B25).  How can I program the average cell such that it will only include the cells which have non 0 numbers in them?

 Answer by tewald Submitted on 3/3/2004 Rating: Rate this answer: N/A Worst Weak OK Good Great If you're using Excel, you could use a formula like this: =SUMIF(B4:B25,"<>0")/COUNTIF(B4:B25,"<>0") You're telling Excel to divide the sum of the non-zero cells by the count of the non-zero cells, which will give you their answer. I see you asked this almost 8 months ago. Guess it's kinda too late now. Tom Ewald

Your answer will be published for anyone to see and rate.  Your answer will not be displayed immediately.  If you'd like to get expert points and benefit from positive ratings, please create a new account or login into an existing account below.

FAQS.ORG reserves the right to edit your answer as to improve its clarity.  By submitting your answer you authorize FAQS.ORG to publish your answer on the WWW without any restrictions. You agree to hold harmless and indemnify FAQS.ORG against any claims, costs, or damages resulting from publishing your answer.

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.