Average Percentages Excluding Zero Percentages

MPHernandez

Guest

Posts: n/a

19th Mar 2008

I was curious to find out how you can find the average percent of a
group of percentages that will exclude percentages of zero.

The example of the incorrect formula is:

=IF(COUNT(H108,I84,I60,I35,I11)>0,AVERAGE(H108,I84,I60,I35,I11),
"0.00%")

**where all the cell numbers are filled with either a percentage
ranging from 0% to 100%

Thanks again,
MPH

« Different chart sizes between Excel 2007 and previous versions | Custom toolbars uninstall/re-install »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Get the Average percentages? Also, #DIV/0! error	Roady	Microsoft Excel Misc	1	26th Sep 2008 08:22 PM
Calculating average of percentages	Jimmy O	Microsoft Excel Programming	7	24th Jun 2008 11:48 PM
how to get percentages?	claudiouk	Microsoft Access Queries	4	12th Mar 2008 01:17 PM
Re: Percentages	swatsp0p	Microsoft Excel Misc	0	13th Sep 2005 05:03 PM
average of percentages between 1% and 100% in a column	SteveMac	Microsoft Excel Misc	1	2nd Apr 2004 06:09 PM