» Summing Values in a Range Containing Redundant Spaces

CATEGORY - Summing VERSION - All Microsoft Excel Versions

Problem:

The numbers in column A contain redundant spaces.
If we try to calculate a total using the SUM function, 0 is returned.

Solution:

Use the SUM, VALUE, and SUBSTITUTE functions as shown in the following Array formula:
{=SUM(VALUE(SUBSTITUTE(A2:A4," ","")))}
Screenshot // Summing Values in a Range Containing Redundant Spaces