» Summing Values in a Range Containing Redundant Spaces
The numbers in column A contain redundant spaces.
If we try to calculate a total using the SUM function, 0 is returned.
Use the SUM, VALUE, and SUBSTITUTE functions as shown in the following Array formula:
|Screenshot // Summing Values in a Range Containing Redundant Spaces|