Sum

[mpima]

How do I sum a row of cells w/ numbers and letters (various) in each cell?

 

[Gary''s Student]

Use =SUM()

for example if A1 thru F1 contains:

1 2 3 qwerty 5 67

then SUM(A1:F1) returns 78
qwerty is treated like a zero.