Hi,

I am trying to sum a set of row that contains Numbers and Texts. Can you help please.

Example:
A B C D E F
M5 M2 M6 P2 P1 B5

I just want colum A7 to A1:F1 sum M5+M2+M6+P2+P1+B5 = 21

I am unable to sum with the letter infront of the number.