» Creating Progressively Incremented Counting Criteria
CATEGORY - Counting
VERSION - All Microsoft Excel Versions
Create a new list in column B where the first value is the number of values in List1 (column A) that are smaller than 1, the second value is the number of values in List1 smaller than 2, and so on.
Solution:
Use the COUNTIF and ROW functions as shown in the following formula in the first cell (B2) of the new list, and copy the formula down the column:
=COUNTIF($A$2:$A$6,"<"&ROW()-ROW($B$2)+1)
Book Store:
Recommended Books:
- Getting to Yes: Negotiating Agreement Without Giving In
- Accounting and Financial Fundamentals for Nonfinancial Executives
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Mortgages For Dummies®
- How to Use Financial Statements: A Guide to Understanding the Numbers
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
Yes, but ...
David J W
But how about if I want to count how many times I have changed the contents of one cell - plus the ability to reset this counter?
