Sum

  • Thread starter Thread starter mpima
  • Start date Start date
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Numbers showing Up Centered in Cell ? 1
Array Function to do a Sum of VLookUps that translate a letter gra 3
Summing rows using formulas with variables 1
Excel Sum numbers in cells that also contain text 34
Sum Formula with variable range 2
Formula autofill to cells below – formula arguments are cell areas in different columns 1
Summing based on a range of criteria 3
IF SUM Formula 2

Back
Top