Forum Discussion

txrussianguy's avatar
txrussianguy
Brass Contributor
Mar 29, 2019

counting contiguous cells

I need to count the contiguous cells on a row, to the right of a cell.  Any way to do that (even though there may be other cells beyond it, and I won't have a firm number on how many that is at any g...
excel
Formulas and Functions
Twifoo's avatar
Twifoo
Silver Contributor
Mar 30, 2019
All references in the formula are relative so that you can copy and paste it anywhere and it will return the count of data cells to the right of the cell where it’s entered.
txrussianguy's avatar
txrussianguy
Brass Contributor
Mar 31, 2019

Twifoo, I think my original request must have not been clear enough. Attached example shows the two shaded cells, into which I need a formula (which I can copy into other cells of similar nature), where the immediately contiguous cells to the right of the formula, are the ones I need to count.

 

Hope that's now clearer.

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Mar 31, 2019
    The formula in B2 is:
    =MATCH(1,
    INDEX(--(C2:$XFD2=""),0),
    0)-1
    • txrussianguy's avatar
      txrussianguy
      Brass Contributor
      Apr 01, 2019

      Twifoo, thanks.  Would love to understand what the formula is doing, inside to out.  I'm not exactly following some of the pieces.  Appreciate the extra explanation.