View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
pchr pchr is offline
external usenet poster
 
Posts: 4
Default Sum all integers of a given number

Hi,
Is there an easy way to arrange a formula that will Sum all integers
of a given number?

such that when applied on colum A, the result will be B:

21 3
77 14
12345 15
1 1
321 6

thanks for you help,
pchr