|
|
#8
05-22-2017, 03:45 AM
|
||||
|
||||
In that case, try this macro after selecting the cells you want totalled
Code:
Sub CountNums()
Dim lngCount As Long: lngCount = 0
Dim oRng As Range
For Each oRng In Selection.Areas(1)
lngCount = lngCount + Split(oRng.Value, " ")(0)
Next oRng
MsgBox "The first numbers add up to: " & lngCount
End Sub
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Sorting numbers within cell
|
michaelst | Excel | 9 | 04-22-2017 10:51 PM |
| Difference between 2 numbers in same cell | Neila1982 | Excel | 1 | 02-12-2017 01:40 AM |
|
Add Numbers from One or Another Cell
|
Kilch | Excel | 3 | 01-31-2017 12:55 PM |
| Search a cell that contains words and numbers and convert the numbers to metric | Carchee | Excel Programming | 36 | 10-08-2014 03:16 PM |
|
adding numbers in same cell
|
jetdude68 | Word Tables | 1 | 07-20-2010 12:30 AM |
Windows 10 
Office 2013
Threaded Mode