• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

1 to 10 - Need to sum the number from 1 to 10

Is there any formula to sum the numbers from first digit to last digit. Eg. if cell "A1" contain "1 to 10", then i need to sum the value from 1 to 10 and output to be display as 55. Also, i want to find the average of the same,
 
Hi,

Pls see attached file
this formula will produce the result up to only 2 digit number

regards
Naresh
 

Attachments

  • Book12.xlsx
    8.9 KB · Views: 11
Back
Top