i want to count numbers from alphanumeric numbers

%3CLINGO-SUB%20id%3D%22lingo-sub-2569720%22%20slang%3D%22en-US%22%3Ei%20want%20to%20count%20numbers%20from%20alphanumeric%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2569720%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%20my%20excel%20column%20as%20alpha%20numeric%20character%20such%20as%26nbsp%3B1E%2C2EW%2C3WO%2C%203EW%20and%20so%20on%20.I%20want%20to%20Sum%20E%26nbsp%3B%20separately%20in%20below%20row%2C%26nbsp%3BSum%20EW%20%2CSum%20WO%20.How%20do%20I%20do%20it%20using%20VBA%20code.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2569720%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2569907%22%20slang%3D%22de-DE%22%3ESubject%3A%20i%20want%20to%20count%20numbers%20from%20alphanumeric%20numbers%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2569907%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F733645%22%20target%3D%22_blank%22%3E%40Rajesh729%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20some%20examples%20inserted%20in%20the%20Excel%20file.%3C%2FP%3E%3CP%3EHope%20I%20can%20help%20you%20with%20that.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 Replies

@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.

 

 

 

 

 

 

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)