Hi @KAUSAIN_SHAKIL - That formula is to concatenate two cells with spaces in between.

If you can are looking to sum the values from A2:A8 , you can do it multiple ways…1. using excel formula by hardcoding the values

2. Get the count of rows and then use it in the Autofill range, after the write cell…

3. Using LINQ

1 Like

Hi,

Use this formula instead to get sum `=SUM(A2:A8)`

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.