Forum Discussion

Coloray13's avatar
Coloray13
Copper Contributor
Nov 29, 2025

Sequential Numbering Based on Specific Text

Hello,

I am having difficulty creating a sequential numbering system in a column, based on specific text (or even better, a checkmark).  I created a table where I often have various rows of data that change depending on the property.  

I have Column C with a dropdown list of ✓ or X.  If I check the row with a ✓, I want it numbered sequentially.  If I select X, I want it omitted from the numbering system.  If left blank, also omitted.  

My formula thus far is:

=IF([@[SelectCOMP]]="✓",(COUNTA($C$14:C20)),"")

This worked great until I introduced the "X" to the dropdown list...

excel
Formulas and Functions

1 Reply

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Dec 01, 2025

    maybe try

    =IF([@[SelectCOMP]]="✓",COUNTIF($C$14:C20,"✓"),"")

    BTW if you want to use table reference throughout you can try this:

    =IF([@[SelectCOMP]]="✓",COUNTIF([[#Headers],[SelectCOMP]]:[@[SelectCOMP]],"✓"),"")