Excel to get Sum of Digits - Need suggestion

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: 394 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
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
ARTICLESHIP 20 October 2026
CA ARTICLE

AMKN & CO

Noida

CA Inter

View Details
Company
12 October 2026
Finance

I-Genext Consulting Private Limited

New Delhi

CA

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
ARTICLESHIP 28 October 2026
Article assistants

Shyam S Gupta and Company

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
19 October 2026
Accountant

Jari Saree Center

New Delhi

Others

View Details
Company
ARTICLESHIP 29 October 2026
Article Assistant (CA Inter / CMA Inter) - Thrissur

Varma Raja & Associates

Thrissur

CA Inter

View Details