|  

» Summing Numerical Substrings

Problem:

List1 (column A) contains text values, each of which consists of a number with the letter "T" at the beginning.
We want to extract the numbers from each string and sum them.

Solution:

Use the SUM, VALUE, and SUBSTITUTE functions as shown in the following Array formula:
{=SUM(VALUE(SUBSTITUTE(A2:A6,"T","")))}



Rate This Tip
12 34 5
Rating:     Views: 4808
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments