=SUMIF(A2:A100,"<>#N/A")

Hi guys can someone modify this above formula so in addition to ignoring #N/A cells it
ignores #DIV/0! also and only sums the cells in the range A2:A100 that have values in
them.

Thanks.