help with ISERR formulas

[Sharon]

I have a formula that I need to take a list of totals and
show the average minus any zero values - if there are no
numbers I need it to show a 0 value in the cell where the
formula is - right now if the column has all 0 values I am
getting the #DIV/0! error - please help - here is an
example of what I have:

=IF(ISERR(V2:V16),(SUM(V2:V16)/COUNTIF(V2:V16,"<>0")),0)

 

[Kevin H. Stecyk]

Sharon,

I think you were very close.

=IF(SUM(V2:V16)<>0,(SUM(V2:V16)/COUNTIF(V2:V16,"<>0")),0)

Hope this helps.

Regards,
Kevin

 

[Guest]

Thanks! That was perfect!

-----Original Message-----
Sharon,

I think you were very close.

=IF(SUM(V2:V16)<>0,(SUM(V2:V16)/COUNTIF(V2:V16,"<>0")),0)

Hope this helps.

Regards,
Kevin

 

[Kevin H. Stecyk]

Thanks! That was perfect!

My pleasure!