JE:

Tried...but when data is entered in e16..n16, I get a blank cell when there
should be an numeric answer. If there is a way I could show you the
worksheet, you cpould better see what I mean.

JT

"JE McGimpsey" wrote:

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