Summing totals in columns where some cells have error values

[Manosh]

Hello all,
Would anyone be able to guide me on how to get the total sum in a
range of cells where some cells have a value but others have a "#DIV/
0"or a "N/A error"?
Thanks in advance!
Manosh

Sample:
5
3
#DIV/0
#N/A
Total = 8

 

[SoftwareMatters]

Sort your data out so that you don't show the errors is the best answer I can give.
Where does the data come from and why are there errors?