Iferror sum formula

Conernesto
Conernesto used Ask the Experts™
I need an Excel formula to add the 6 items listed below.  I tried doing a formula with IFERROR. Thank you.

 -  
 -  
 43,908
 777,037
 #ERROR: ARB51_RESERVE
 #ERROR: BRANDSERVICES
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Finance Analyst
Commented:
Assuming values in cells A1 to A6, just =SUM(A1:A6) will do it, with result of 820945, the sum of the two numbers.

SUM function ignores text.
Conernesto

Author

Commented:
You are absolutely correct. Thank you.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial