Excel to get Sum of Digits - Need suggestion

1746 views 5 replies

Pls go through this file and let me know how can you make it simplified.

You can get sum of digits in a cell e.g. if you have 1564 in a cell then the total of 1+5+6+4=16 is automatically shown by the formula.

Invited your suggestions to make it simple :) Cheers :)

 


Attached File : 41 excel to get sum of digits in single cell.xlsx downloaded: 363 times
Replies (5)

can u make it in 2003 format not everybody have ms excel2007

Good one!!

can u make it in 2003 format not everybody have ms excel2007

This is the problem with my formula. It wont work in excel 2003 as i used line of formula's in a single cell which is not compitible for excel 2003.

still i will try to provid the same in excel 2003

Here find attached excel 2003 format. Thanks for your suggestiojns :)

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
ARTICLESHIP 10 July 2026
Article Assistant

N S Gokhale & Co

Thane

CA Inter

View Details
Company
ARTICLESHIP 07 July 2026
Articleship

Jawahar and Associates Chartered Accountants

Hyderabad

CA Inter

View Details
Company
05 July 2026
Financial Controller

NovumLake Partners

Mumbai

CA

View Details
Company
ARTICLESHIP 23 July 2026
Article

Gianender & Associates

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 16 July 2026
CA Article

Pipara & Co. LLP.

Mumbai

CA Inter

View Details
Company
ARTICLESHIP 11 July 2026
Article

SNCO

Mumbai

CA Inter

View Details
Company
16 July 2026
Manager - Finance & Accounts

Aliens Group

Hyderabad

CA Final

View Details
Company
ARTICLESHIP 30 June 2026
Article Assistant or Paid Assistant

VIKAS VERMA & CO

New Delhi

Others

View Details