How do I add a cell with a label behind it

N

NETTA

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?
 
R

Richard Buttrey

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
__________________________
 
Top