banner_ad

Excel to get Sum of Digits - Need suggestion

Others 1733 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: 361 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 :)


CCI Pro

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Related Topics
Loading
Company
29 May 2026
Finance Head

Bhawar Sales Corporation

Chennai

Graduate (Any)

View Details
Company
ARTICLESHIP 28 May 2026
Accounts, Audit & Compliance Executive

Shyam Joshi & Associates

Pune

B.Com

View Details
Company
27 May 2026
Audit Assitant

Virender K Gupta and Co

New Delhi

B.Com

View Details
Company
14 May 2026
Senior Associate

ABHISHEK SHANKAR AGARWAL & ASSOCIATES

Kolkata

CA

View Details
Company
21 May 2026
Associate

PWC

Kolkata

CA

View Details
Company
14 May 2026
ICSI Trainees for 21 Months and Semi-Qualified CS

CMNITY HIRE

New Delhi

Others

View Details
Company
23 May 2026
Account Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
19 May 2026
Accountant

ca kunjan

Mumbai

CA Inter

View Details