Posted to microsoft.public.excel.misc

EAB1977

external usenet poster

Posts: 39

Average Formula Help

Hello everyone,

I have a set of percents (cells B30 - I30) that I would like to
average, but I want to eliminate any percents that equal zero. Using
the average function, it takes into account zeros, thus skewing my
average. Is there a function that I can use that will eliminate zeros
from my average and give a true percent average?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Average Formula	sross002	Excel Discussion (Misc queries)	6	February 14th 10 06:20 PM
Average formula	wannabe68	Excel Discussion (Misc queries)	4	April 13th 08 03:34 AM
help with an average formula	gnasher	Excel Worksheet Functions	1	March 6th 08 10:55 PM
A formula to AVERAGE IF but only average a set number of values	[email protected]	Excel Worksheet Functions	2	January 31st 08 08:28 PM
how does one convert text to a formula "average(A:A)" to =average(	phshirk	Excel Worksheet Functions	4	April 14th 05 01:20 AM

All times are GMT +1. The time now is 06:09 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us