How can I get a formula to ignore " " entries

[mactoolsix]

I have a columns with results = " "
When I add up multiple columns (one containing " ") get a "#value" error.

Is there a way to have the formula ignore " " ?

 

[Joe4]

Apparently, this question is ALSO being asked here: https://www.mrexcel.com/forum/excel-...e-answers.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).