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.