One way:
=IF(ISERROR(SUM(E16:N16)/O16),"",SUM(E16:N16)/O16)
Much more efficient, and won't mask other errors:
=IF(O16=0,"",SUM(E16:N16)/O16)
In article ,
"JT" wrote:
Thanks but I'm still having trouble. Following is the formula I'm
using...can you show me how to include the ISERROR function? When I do it,
then input data in the e16..n16 range, I get the FALSE error.
=SUM(E16:N16)/O16
|