Summing and Ignoring - #DIV/0!

[Celticshadow]

Hi All

I have a row of figures in this case percentages that look similar to the below. My question is how do I automatically sum the row if it contains one or more of these errors #DIV/0!


71% 16% 53% #DIV/0!

(The row in this case starts at A1 and can be up to ten columns long)

Thanks in advance.

Kind Regards

 

[T. Valko]

Hi All

I have a row of figures in this case percentages that look similar to the below. My question is how do I automatically sum the row if it contains one or more of these errors #DIV/0!


71% 16% 53% #DIV/0!

(The row in this case starts at A1 and can be up to ten columns long)

Thanks in advance.

Kind Regards

The easiest thing to do is to correct the formula so that it doesn't return the error then a simple =SUM(...) will do.

With that being said, try this...

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

 

[Celticshadow]

Hi T. Valko

That works perfectly, many thanks for your help.

Kind Regards

 

[T. Valko]

Hi T. Valko

That works perfectly, many thanks for your help.

Kind Regards

You're welcome. Thanks for the feedback!