Iferror sum formula

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.

Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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.
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