|
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 |
Newsgroups: microsoft.public.excel.newusers
From: JBeaucaire <jb...@madrocketscientist.com.NOSPAM>
Date: Fri, 6 Nov 2009 23:29:01 -0800
Local: Sat, Nov 7 2009 3:29 pm
Subject: RE: work book on Excel 07
Try this:
=SUM(F10,F13,F16,F19,F22,F26,F30) / COUNTA(F10,F13,F16,F19,F22,F26,F30) Your feedback is appreciated, click YES if this post helped you. "Beth Gaines" wrote:
> I want to average a group of percentages but want to exlude cells which have > the value 0 (some of the cells have 0 for the numerator and denominator). > What would the formula be? What I have so far is > =(F10+F13+F16+F19+F22+F26+F30)/7 > What I want to do is exclude F19 for example if its value is 0 rather than > 0%. Any suggestions? > Thanks much. You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
| |||||||||||||