» 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:
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?
