How do I add a cell with a label behind it

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to add all 0.5S or 0.5V in a rowl. How do I get excel to recognize
that 0.5 is a number with the label behnd it?
 
I need to add all 0.5S or 0.5V in a rowl. How do I get excel to recognize
that 0.5 is a number with the label behnd it?
Click to expand...

Assuming the labels are in A1:J1, and that there is only one label
character at the end of the number, then the following array formula
entered in a single cell with CTRL SHIFT and Enter will work.

=SUM(VALUE((LEFT(A1:J1,LEN(A1:J1)-1))))

If the number of label characters vary then you'd have to find some
way of spotting which they are and amend the formula accordingly.

Alternatively you could just use a helper row, say A2 and copied
across to J2:

=VALUE((LEFT(A1:J1,LEN(A1:J1)-1))

Then sum row 2

HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
You must log in or register to reply here.

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

adding numbers with a label 3
number of cells 3
Excel - count if a number falls within an array in a column & add 3
Excel Changing chart label colors based on a value in a cell 0
Adding custom x axis labels to histogram generated from a pivot table 1
How do I get to add up only the values > than 0? 1
Hide Rows or Columns with +/- button above row/column label headin 2
How can I add up multiple IF results. 3

Back
Top