sum numbers which contains characters

  • Thread starter Thread starter jacobs
  • Start date Start date
J

jacobs

in column A (A1:A11)
m
4A
8A
m
Tr
m
m
4A
4A
8A
8A

i would like to add up all the 4A and 8A so that my total column would
be 36A
how can i do that?
many thanks for any help
 
If there will only be 4A and 8A (not 3A, 5A etc) then
=(COUNTIF(A1:A11,"4A")*4+COUNTIF(A1:A11,"8A")*8)&"A"
best wishes
 
Back
Top