How to sum cells and ignore the #div/0! 's ?

 

Question Info


Last updated February 14, 2020 Views 64,062 Applies to:
Answer
Answer
jht wrote:
> How to sum cells and ignore the #div/0! 's ?

IMHO, it is best to avoid the #DIV/0 errors in the first place.  If you want help with that, provide some example formulas.

Otherwise, try:

=SUMIF(B1:B1000,"<>#DIV/0!")

117 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Answer
Answer

Hi,,

 

Try this

 

=SUMIF(A1:A100,"<1E100")

If this response answers your question then please mark as answer.

Mike H

49 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.