Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: work book on Excel 07 in microsoft.public.excel.newusers
Started 1 month, 3 weeks ago by Beth Gaines
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?...
Site: Discussions in microsoft.public.excel.newusers  Discussions in microsoft.public.excel.newusers - site profile
Forum: microsoft.public.excel.newusers  microsoft.public.excel.newusers - forum profile
Total authors: 2 authors
Total thread posts: 2 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Other posts in this thread:

JBeaucaire replied 1 month, 3 weeks ago
Try this: =SUM(F10,F13,F16,F19,F22,F26,F30) / COUNTA(F10,F13,F16,F19,F22,F26,F30) -- "Actually, I *am* a rocket scientist." -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if this post helped you. "Beth Gaines" wrote: > I want to average a group of percentages but want...
Size: 1,137 bytes
Customize:  Customize "<b>Reply 1</b>: work book on Excel 07 in microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"

 

Top contributing authors

Name
Posts
JBeaucaire
1
user's latest post:
work book on Excel 07 in...
Published (2009-11-06 23:28:00)
&nbsp; Try this: =SUM(F10,F13,F16,F19,F22,F26,F30) / COUNTA(F10,F13,F16,F19,F22,F26,F30) -- &quot;Actually, I *am* a rocket scientist.&quot; -- JB (www.MadRocketScientist.com) Your feedback is appreciated, click YES if this post helped you. &quot;Beth Gaines&quot; wrote: &gt; I want to average a group of percentages but want to exlude cells which have &gt; the value 0 (some of the cells have 0 for the numerator and...
Beth Gaines
1
user's latest post:
work book on Excel 07 in...
Published (2009-11-06 14:36:00)
&nbsp; 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. &nbsp;

Related threads on "Discussions in microsoft.public.excel.newusers":

Suggestion or recommendation for a good Excel reference...  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile Suggestion or recommendation for a good Excel reference book in microsoft.public.excel.newusers
Suggestion or recommendation for a good Excel reference book in microsoft.public.excel.newusers
Outlook 2000 Address Book in microsoft.public.excel.newusers  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile Outlook 2000 Address Book in microsoft.public.excel.newusers
Outlook 2000 Address Book in microsoft.public.excel.newusers
How do I check for duplicates in multiple sheets (in one...  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile How do I check for duplicates in multiple sheets (in one book)? in microsoft.public.excel.newusers
How do I check for duplicates in multiple sheets (in one book)? in microsoft.public.excel.newusers
No More New Fonts May Be Applied To This Work Book in...  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile No More New Fonts May Be Applied To This Work Book in microsoft.public.excel.newusers
No More New Fonts May Be Applied To This Work Book in microsoft.public.excel.newusers
What is "Book 1" in excel? in...  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile What is "Book 1" in excel? in microsoft.public.excel.newusers
What is "Book 1" in excel? in microsoft.public.excel.newusers
Is there a good how to book that I can buy for excel...  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile Is there a good how to book that I can buy for excel 2007? in microsoft.public.excel.newusers
Is there a good how to book that I can buy for excel 2007? in microsoft.public.excel.newusers
How to clean one book using data from another? in...  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile How to clean one book using data from another? in microsoft.public.excel.newusers
How to clean one book using data from another? in microsoft.public.excel.newusers
Export to Microsoft Excel missing from shortcut menu in...  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile Export to Microsoft Excel missing from shortcut menu in microsoft.public.excel.newusers
Export to Microsoft Excel missing from shortcut menu in microsoft.public.excel.newusers
Microsoft Excel Formulas in microsoft.public.excel.newusers  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile Microsoft Excel Formulas in microsoft.public.excel.newusers
Microsoft Excel Formulas in microsoft.public.excel.newusers
Copying a donor mail list from excel into Microsoft works...  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile Copying a donor mail list from excel into Microsoft works database in microsoft.public.excel.newusers
Copying a donor mail list from excel into Microsoft works database in microsoft.public.excel.newusers

Related threads on other sites:

Is there a simple way to get data from an excel...  Discussions in microsoft.public.mac.office.excel - site profile microsoft.public.mac.office.excel - forum profile Is there a simple way to get data from an excel spreadsheet into mac address book in microsoft.public.mac.office.excel
Is there a simple way to get data from an excel spreadsheet into mac address book in microsoft.public.mac.office.excel
Search within an excel address book in...  Discussions in microsoft.public.mac.office.excel - site profile microsoft.public.mac.office.excel - forum profile Search within an excel address book in microsoft.public.mac.office.excel
Search within an excel address book in microsoft.public.mac.office.excel
Importing an Excel File into Address Book in...  Discussions in microsoft.public.mac.office.excel - site profile microsoft.public.mac.office.excel - forum profile Importing an Excel File into Address Book in microsoft.public.mac.office.excel
Importing an Excel File into Address Book in microsoft.public.mac.office.excel
???book for microsoft excel 2003  منتديات الصايرة - site profile منتدى الكتب الإلكترونية - forum profile ???book for microsoft excel 2003
???book for microsoft excel 2003
Merge excel data into Giant Print Address Book in...  Discussions in microsoft.public.word.pagelayout - site profile microsoft.public.word.pagelayout - forum profile Merge excel data into Giant Print Address Book in microsoft.public.word.pagelayout
Merge excel data into Giant Print Address Book in microsoft.public.word.pagelayout
How can I import data from an Excel sheet to my e-mail...  Discussions in microsoft.public.outlook.contacts - site profile microsoft.public.outlook.contacts - forum profile How can I import data from an Excel sheet to my e-mail addr book? in microsoft.public.outlook.contacts
How can I import data from an Excel sheet to my e-mail addr book? in microsoft.public.outlook.contacts
Can I import 2000 excel file to 2007 outlook address...  Discussions in microsoft.public.outlook.contacts - site profile microsoft.public.outlook.contacts - forum profile Can I import 2000 excel file to 2007 outlook address book? in microsoft.public.outlook.contacts
Can I import 2000 excel file to 2007 outlook address book? in microsoft.public.outlook.contacts
Excel Reference Book in microsoft.public.excel  Discussions in microsoft.public.excel - site profile microsoft.public.excel - forum profile Excel Reference Book in microsoft.public.excel
Excel Reference Book in microsoft.public.excel
Excel Cook Book in microsoft.public.windows.powershell  Discussions in microsoft.public.windows.powershell - site profile microsoft.public.windows.powershell - forum profile Excel Cook Book in microsoft.public.windows.powershell
Excel Cook Book in microsoft.public.windows.powershell
Have to keep renewing links every time I open a work book...  Discussions in microsoft.public.mac.office.excel - site profile microsoft.public.mac.office.excel - forum profile Have to keep renewing links every time I open a work book in microsoft.public.mac.office.excel
Have to keep renewing links every time I open a work book in microsoft.public.mac.office.excel
Thread profile page for "work book on Excel 07 in microsoft.public.excel.newusers" on http://www.microsoft.com/communities/newsgroups.... This report page is a snippet summary view from a single thread "work book on Excel 07 in microsoft.public.excel.newusers", located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity