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: 366 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
Featured 12 September 2026
Assistant Manager - Finance & Compliance

Naveen Fintech Pvt Ltd

Kolkata

CA Inter

View Details
Company
16 September 2026
Internal Audit - Team Lead

Consulting & Beyond

Chennai

CA

View Details
Company
29 August 2026
Chartered Accountant

Velionit Consulting PVT LTd

Mumbai

CA

View Details
Company
08 September 2026
Audit Executive

Thammana & Associates

Srikakulam

B.Com

View Details
Company
04 September 2026
CA inter Or ca finalist

A Jaiswal and company

Lucknow

CA Final

View Details
Company
24 August 2026
Semi-Qualified CA/CA Finalist - Tax, GST, Audit & Accounts

Bharat Shah & Associates

Mumbai

CA Inter

View Details
Company
Featured 11 September 2026
Audit Executive

RBSM Corporate Advisors Private Limited

Pune

CA

View Details
Company
ARTICLESHIP 15 September 2026
Freelance Taxation Content Writer Intern

Interactive Media Pvt Ltd.

New Delhi

CA Inter

View Details