LinkBack URL
About LinkBacks
Hello all,
I'm having difficulty adding up a row and a column with cells containing both numbers and text.
Here's an example:
Capture.PNG
Hello all,
I'm having difficulty adding up a row and a column with cells containing both numbers and text.
Here's an example:
Capture.PNG
Hi, welcome to the forum
It is always better to upload a sample workbook, rather than a pic, we cant work with images.
Having said that, see if this will get you started - you will need to apply this for each cell, then add them together...
1 aaa, 2 bbb, 3 ccc
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
One possible way, using VBA (paste the code into a module).
The syntax for the USF is =SumNumbers(A1). Copy down.
Formula:
Please Login or Register to view this content.
Then add them up as normal.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
ooooops forgot to add the formula duh...Originally Posted by FDibbins
Hi, welcome to the forum
It is always better to upload a sample workbook, rather than a pic, we cant work with images.
Having said that, see if this will get you started - you will need to apply this for each cell, then add them together...
1 aaa, 2 bbb, 3 ccc
B9=SUMPRODUCT(LEN(A9)-LEN(SUBSTITUTE(A9,{1,2,3,4,5,6,7,8,9},"")),{1,2,3,4,5,6,7,8,9})
Another thing... What is the range of numbers used? Are they always single digits (or at least always the same number of digits) - or do they vary widely????
Thanks for the speedy reply! They will always be only 1 digit numbers.
Thank you!
It works perfectly! But is there anyway that I could add rows/columns that contains similar cells like that?
Sorry if I'm being nitpicky lol
Who are you talking to???
Can you provide an example?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks