i want to count numbers from alphanumeric numbers

[Rajesh729]

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.

[#2]

@Rajesh729 

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.

[#3]

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)