Summing Values in a Range Containing Redundant Spaces

 

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
Summing Values in a Range Containing Redundant Spaces



Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>