Forum Discussion
i want to count numbers from alphanumeric numbers
hi my excel column as alpha numeric character such as 1E,2EW,3WO, 3EW and so on .I want to Sum E separately in below row, Sum EW ,Sum WO .How do I do it using VBA code.
Here are some examples inserted in the Excel file.
Hope I can help you with that.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
Missed the summation, as always the thought was faster than the eye can read :)).
=COUNTIF(A1:A6,"U")
That would be the simplest form of adding up alphanumeric numbers.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)
=COUNTIF(A1:A6,"U")
That would be the simplest form of adding up alphanumeric numbers.
Thank you for your patience and time.
Nikolino
I know I don't know anything (Socrates)