Tip Printed from ExcelTip.com

---

Creating Progressively Incremented Counting Criteria


Problem:

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)