Posted to microsoft.public.excel.programming

tom[_9_]

external usenet poster

Posts: 3

Average Without Zeroes

My spread sheet contains already some COUNTIF formula which are working
okay.

As soon as i try to change which cells are included in the formula so
they do not go in sequence i get the #VALUE! coming up

the one that works goes as follows

=SUM(AA200:AA205)/COUNTIF(AA200:AA205,"<0")

the one that doesnt is

=SUM(AA207:AA211,AA217)/COUNTIF((AA207:AA211,AA217),"<0")

Any suggestions?

Thanks

Tom

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
disregarding zeroes	Sapper	Excel Discussion (Misc queries)	4	April 27th 09 02:28 PM
Can you eliminate zeroes	JimS	Excel Discussion (Misc queries)	2	April 21st 09 08:47 AM
Can I set the default for "show zeroes" to not show the zeroes?	jeel	Setting up and Configuration of Excel	1	January 25th 08 07:18 PM
F5 function for zeroes?	Lee Harris	Excel Worksheet Functions	3	November 22nd 05 10:24 PM
Leading Zeroes	Ken	Excel Discussion (Misc queries)	1	October 7th 05 03:17 PM

All times are GMT +1. The time now is 07:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us