KMHarpe

Posts: n/a

How do I average a formula without calculating zero values?

I want to average a column, except for the cells that have zero as a value.
How do I do this?

Thanks!

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
Formula to average certain times	Denise	Excel Discussion (Misc queries)	5	July 18th 05 01:02 PM
Formula to Average times...again	Denise	Excel Discussion (Misc queries)	1	July 15th 05 08:26 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
Formula for calculating time	kc sunshine	Excel Worksheet Functions	2	April 26th 05 08:38 PM
Histrogramms: Calculating average and standard deviation	Jens Eichelbaum	Excel Worksheet Functions	2	November 23rd 04 02:10 AM

All times are GMT +1. The time now is 09:03 PM.

About Us

"It's about Microsoft Excel"