Posted to microsoft.public.excel.worksheet.functions

Gary

external usenet poster

Posts: 143

Average ignoring Zeros

=AVERAGE(IF(Start:End!C22<0,Start:End!C22,""))

Hi All can anyone tell me what's wrong with the above mentioned formula? I
am pressing CTRl+SHIFT+ENTER.

What I am trying to do here is, take the average of cell C22 from all the
sheets between the two sheets named as Start and End ignoring all the zero
values.

Thanks for any help.
Gary

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
30 Day Moving Average Ignoring Blank Cells	ethatch	Excel Worksheet Functions	2	January 17th 06 09:37 AM
Conditional Average Ignoring Blanks	Dirk Friedrichs via OfficeKB.com	Excel Worksheet Functions	2	May 6th 05 03:49 PM
Averaging noncontiguous numbers ignoring zeros?	Mike	Excel Worksheet Functions	19	March 4th 05 02:05 AM
Averaging, ignoring zeros	Mark	Excel Worksheet Functions	5	February 28th 05 10:25 PM
Formula to average ignoring negatives?	Steve	Excel Discussion (Misc queries)	16	January 1st 05 12:57 PM

All times are GMT +1. The time now is 03:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us