Posted to microsoft.public.excel.worksheet.functions

John[_22_] John[_22_] is offline

external usenet poster

Posts: 694

#Div/0 error, can't get rid of it

Hi Everyone
I use this array formula and it works well,
=IF(COUNT(J5:J36)<1,"",AVERAGE(IF(J5:J360,J5:J36, "")))
But if I only have 0 in that column, I get #Div/0, I tried this version
=IF(ISERROR(COUNT($K$5:$K$36)=0),"",AVERAGE(IF($K$ 5:$K$360,$K$5:$K$36,""))) but
to no avail.
Anyone can help me with this.
Thanking you in advance
John

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
Visual Basic Error Run Time Error, Type Mismatch	Meg Partridge	Excel Discussion (Misc queries)	12	September 10th 08 06:10 PM
Error of slope taking into account error of the data points	cer144	Excel Worksheet Functions	5	July 7th 08 07:26 PM
Counting instances of found text (Excel error? Or user error?)	S Davis	Excel Worksheet Functions	5	September 12th 06 04:52 PM
I have Error 1919 Error Configuring ODBC dataSource Database	Texanna1	Excel Discussion (Misc queries)	1	September 12th 06 06:35 AM

All times are GMT +1. The time now is 10:34 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us