» Summing Numerical Substrings
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
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","")))}
Book Store:
Recommended Books:
- What the IRS Doesn't Want You to Know: A Cpa Reveals the Tricks of the Trade
- Accounting Principles, with CD, 6th Edition
- Harry Potter and the Order of the Phoenix (Book 5)
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- East of Eden (Oprah's Book Club)
No comments have been submitted.

