Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Ignoring #DIV/0!
How can I make excel ignore a #DIV/0! error when averaging a range of cells??? -- tillyosu ------------------------------------------------------------------------ tillyosu's Profile: http://www.excelforum.com/member.php...o&userid=25114 View this thread: http://www.excelforum.com/showthread...hreadid=388049 |
#2
|
|||
|
|||
An if statement that does the averaging calc only when it is not zero.
"tillyosu" wrote: How can I make excel ignore a #DIV/0! error when averaging a range of cells??? -- tillyosu ------------------------------------------------------------------------ tillyosu's Profile: http://www.excelforum.com/member.php...o&userid=25114 View this thread: http://www.excelforum.com/showthread...hreadid=388049 |
#3
|
|||
|
|||
Something like
=IF(B1=0,"",A1/B1) -- HTH RP (remove nothere from the email address if mailing direct) "tillyosu" wrote in message ... How can I make excel ignore a #DIV/0! error when averaging a range of cells??? -- tillyosu ------------------------------------------------------------------------ tillyosu's Profile: http://www.excelforum.com/member.php...o&userid=25114 View this thread: http://www.excelforum.com/showthread...hreadid=388049 |
#4
|
|||
|
|||
tillyosu wrote...
How can I make excel ignore a #DIV/0! error when averaging a range of cells??? Meaning something like AVERAGE(B5:D10) returns #DIV/0! ? That only happens when there are no numeric values in the range or when one or more of the cells in the range evaluates to #DIV/0! . You probably shouldn't ignore the latter. As for the former, it depends on what you want to show, but the generic approach is =IF(COUNT(B5:D10),AVERAGE(B5:D10),"") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to sum cells and ignore the #div/0! 's ? | Excel Worksheet Functions | |||
How do i make a sum formula ignore #div/0! errors in the range | Excel Worksheet Functions | |||
replace "#DIV/0!" error with blanks | Excel Worksheet Functions | |||
# DIV/0! error in Excel | Excel Discussion (Misc queries) | |||
Ignoring #DIV/0! in a formula | Excel Discussion (Misc queries) |