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