Remember Me?

#1
October 2nd 09, 07:13 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 181
Averageif Error

I am using the formula

averageif(\$G219:\$N219,"<0") in my workbook however if one of the cells
contains "0" it returns the error #DIV/0!

Why and how can I get rid of it

Thanks

#2
October 2nd 09, 07:22 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Mar 2009 Posts: 8,521
Averageif Error

In excel 2007 the below works if atleast there is one entry which is not = 0
=AVERAGEIF(\$G219:\$N219,"<0")

If you mean to avoid div error if all the cell values are 0 then try the below
=IF(SUM(\$G219:\$N219),AVERAGEIF(\$G219:\$N219,"<0"), "")

If this post helps click Yes
---------------
Jacob Skaria

"Curtis" wrote:

I am using the formula

averageif(\$G219:\$N219,"<0") in my workbook however if one of the cells
contains "0" it returns the error #DIV/0!

Why and how can I get rid of it

Thanks

#3
October 2nd 09, 10:02 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 35,218
Averageif Error

Actually, you're getting the error if there are no cells that are non-zero,
right?

If the range is always numeric, then you could use:

Or you could check to see if the only numbers were 0's:

Curtis wrote:

I am using the formula

averageif(\$G219:\$N219,"<0") in my workbook however if one of the cells
contains "0" it returns the error #DIV/0!

Why and how can I get rid of it

Thanks

--

Dave Peterson

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post T. Valko Excel Worksheet Functions 9 July 15th 09 07:01 PM MUmfleet Excel Discussion (Misc queries) 5 April 9th 09 04:53 PM coastal Excel Discussion (Misc queries) 1 November 14th 07 12:28 AM name Excel Worksheet Functions 1 May 4th 06 05:27 PM rudy Excel Discussion (Misc queries) 5 April 27th 06 11:20 PM

All times are GMT +1. The time now is 08:21 AM.