Sum Without Error

Sum Without Error:

If the Column contains error then summing up with formula
=sum(range), will show an error too.

First, get all the error as blank and then sum it.

For that use array function, 

{=sum(iferror(range,""))}

For array function write in formula bar

=sum(iferror(c4:c17,"")) and press ctrl+shift+enter

Similarly you can do this with average, count, max or min function

Thanks