Find the sum of Comma Seperated Values In a Cell

  • Thread starter Thread starter xcelion
  • Start date Start date
X

xcelion

Hi All,
Can anyone help me in writting a formula to find the sum of comma
separated numbers in a cell
Thanks in advance
Xcelion
 
Thanks sirknightly for you answer

This looks fine But i would like to know whether this can be expresses
as formula
 
Good morning xcelion

As sirknightly says it can't be done by Excel without resorting t
writing your own function - and the one he supplied works just fine.

HTH

Dominic
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of comma seperated values in cell(Reposting) 3
Nees Function to Split 3
Help! Formula to find the address of particular value in sheet 2
Excel How to add numbers in same cell? 2
All functions that use commas aren't working! 1
Excel formula, sum the value cell and if empty cell left blank 0
number to character and vice-versa 8
Replace Comma's with Dash 2

Back
Top