View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Green Fox Green Fox is offline
external usenet poster
 
Posts: 7
Default summing 2 to 8 separate numbers in a single cell

I have a group of numbers in a single cell, i.e.: 14 6 8 14 6 8. I
would like a formula that provides the sum of those numbers. I thought
I had seen a way to do that a few years ago, but my searches are
coming up empty. Should I be using text functions to isolate numbers,
or would I be better off trying to turn it into an array? It doesn't
seem that it should be that hard, but it's confounding me — maybe it's
lack of sleep...

Andy