Posted to microsoft.public.excel.misc

Peter

external usenet poster

Posts: 349

Average Formula

How can I write the average formula so it does not count the cells with zeros
in it...
A1= 12
A2= 0
A3 = 12
A4 = 0
A5= 12
A6 =0
if I write the formula as =average(a1:a6) the value is 6, but I want it to
read 12.

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	Pammy	Excel Discussion (Misc queries)	1	June 26th 08 03:51 AM
AVERAGE Formula Help	Steph	Excel Discussion (Misc queries)	2	May 16th 08 07:49 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
Average Formula	racerx66	Excel Discussion (Misc queries)	3	October 10th 07 05:58 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 08:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us