» Counting the Number of Strings which Contain Numbers Meeting Criteria
CATEGORY - Excel Counting
VERSION - All Microsoft Excel Versions
List1 (column A) contains strings composed of the letter "T" and a number (i.e. T1,T2,,,,T100).
We want to count the number of strings in List1 which contain a number smaller than the one in a specified string of the same format.
Solution:
Use the SUMPRODUCT, SUBSTITUTE, and VALUE functions as shown in the following formula:
=SUMPRODUCT(--(VALUE((SUBSTITUTE($A$2:$A$7,"T","")))
Book Store:
Recommended Books:
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- The Fall of Advertising and the Rise of PR
- The Intelligent Investor: The Classic Bestseller on Value Investing
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Microsoft Excel 2002 Formulas (With CD-ROM)
No comments have been submitted.
