=COUNTIFS(A$2:A2, A2)

This is where becomes essential. It transforms Excel from a static grid into a dynamic database engine. Conditional numbering is not about counting cells; it is about assigning an incremental identity based on logical tests. This essay explores the three primary paradigms for conditional numbering in Excel: the COUNTIF expanding range, the SUBTOTAL function for filtered data, and the COUNTIFS multi-condition ranking. 1. The Classic Sequential Condition: The Expanding Range The most fundamental conditional numbering problem is: "Number only the rows where Column A is not empty, ignoring blanks."

that also ignores blanks:

Enter SUBTOTAL with function number 103 (or 3 for classic counting). The formula is:

=IF(SUBTOTAL(103, A2)=1, SUBTOTAL(103, A$2:A2), "")

Using LET (Excel 365):

This requires COUNTIFS (or SUMIFS with a logical trick). Assume Column A is Category, Column B is Item. In C2:

The principle is sound: you must create a helper column that marks visibility ( =SUBTOTAL(103, A2) ), then use COUNTIFS on that helper column. This pushes Excel to its logical limits. To number cells with conditions is to understand that spreadsheets are not merely ledgers but interactive models. The simple fill handle sees no difference between a data row and an empty spacer. The conditional formula, however, sees context: blanks, filters, categories.