Posted to microsoft.public.excel.programming

Jimmy O[_2_] Jimmy O[_2_] is offline

external usenet poster

Posts: 1

Calculating average of percentages

I have a column of percentage values some of which are zeros. I wish to
calculate an average of the percentage values but also wish to exclude all
zero values from the average formula but I'm not sure how to write an
argument to do this. Any help is appreciated.

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
calculating percentages	lindamac	Excel Discussion (Misc queries)	2	May 7th 10 12:02 AM
Average Percentages Excluding Zero Percentages	MPHernandez	Excel Programming	0	March 19th 08 06:54 PM
Calculating percentages	Louise	Excel Discussion (Misc queries)	4	December 9th 05 04:12 PM
calculating percentages	msdobe	Excel Discussion (Misc queries)	6	July 29th 05 04:46 PM
Calculating Percentages	tifosi3	Excel Discussion (Misc queries)	7	July 11th 05 08:42 PM

All times are GMT +1. The time now is 02:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us