» Summing Numerical Substrings
CATEGORY - Excel Summing
VERSION - All Microsoft Excel Versions
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","")))}
Book Store:
Recommended Books:
- Special Edition Using Microsoft Access 2002
- Special Edition Using Microsoft Office XP
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Accounting Principles, with CD, 6th Edition
- The Financial Numbers Game: Detecting Creative Accounting Practices
No comments have been submitted.

