Register
Help
Remember Me?
Forum
Forum Home
New Posts
FAQ
Calendar
Community
Member List
Forum Actions
Mark Forums Read
Quick Links
Today's Posts
View Site Leaders
What's New?
Zero Reply Posts
Advanced Search
Forum
Help Section
Excel Help
Sum Of The Digits Of Numeric Value In A Cell Range
If this is your first visit, be sure to check out the
FAQ
by clicking the link above. You may have to
register
before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.
Also, to ensure that your UserName is registered, please ensure that you have confirmed your e-mail address by clicking on the link that will be sent to your address.
Users who do not confirm their e-mail addresses will be able to browse the forum, but not able to download any content
Results 1 to 9 of 9
Thread:
Sum Of The Digits Of Numeric Value In A Cell Range
Thread Tools
Show Printable Version
Email this Page…
Display
Switch to Linear Mode
Switch to Hybrid Mode
Threaded Mode
Threaded View
Previous Post
Next Post
04-22-2013,
10:10 PM
#2
Rick Rothstein
View Profile
View Forum Posts
Private Message
Forum Guru
Join Date
Feb 2012
Posts
662
Rep Power
15
Give this formula a try...
=SUMPRODUCT(--MID(A1,ROW(INDIRECT("A1:A"&LEN(A1))),1))
Reply With Quote
Quick Navigation
Excel Help
Top
Site Areas
Settings
Private Messages
Subscriptions
Who's Online
Search Forums
Forums Home
Forums
Zone of the Champions
Rick Rothstein's Corner
Rajan Verma's Corner
Tips, Tricks & Downloads (No Questions)
ETL PQ Tips and Tricks
Excel and VBA Tips and Tricks
Familiar with Commands and Formulas
MS-Access Tips And Tricks
Download Center
Den Of The Fox
Greetings and Inception
Test Area
Public News
Help Section
Excel Help
Access Help
Word Help
Powerpoint Help
Outlook Help
Power Query, Power Pivot and Power BI
Hire A Developer
Ribbon: Fluent User Interface
Excel Ribbon and Add-Ins
Classic Menu
«
Previous Thread
|
Next Thread
»
Similar Threads
Sum Of The Digits In A Cell Using Formula
By venkat1926 in forum Excel Help
Replies:
0
Last Post:
04-30-2013,
07:11 PM
Sumproduct Formula To Sum Range With Criteria On Numeric Text
By Howardc in forum Excel Help
Replies:
11
Last Post:
04-07-2013,
07:51 PM
Macro for if cell A2 has text then cell B2 must have numeric value.
By Carlos Arruda in forum Excel Help
Replies:
5
Last Post:
03-09-2013,
09:01 AM
Sum Ifs Formula needed with Max Date range
By trankim in forum Excel Help
Replies:
2
Last Post:
09-19-2012,
09:50 AM
Align all text in Left and all numeric values in center in a given range using vba.
By LalitPandey87 in forum Excel Help
Replies:
2
Last Post:
02-29-2012,
08:24 PM
Bookmarks
Bookmarks
Digg
del.icio.us
StumbleUpon
Google
Facebook
Posting Permissions
You
may not
post new threads
You
may not
post replies
You
may not
post attachments
You
may not
edit your posts
BB code
is
On
Smilies
are
On
[IMG]
code is
On
[VIDEO]
code is
On
HTML code is
Off
Forum Rules
Posting Permissions
Reply With Quote
Bookmarks