Forum Discussion

AVP68's avatar
AVP68
Copper Contributor
May 06, 2019
Solved

COUNTIF WITH OFFSET

Hello, I have a the following formula in row I57, COUNTIF(I6:I56,"<>0), which works fine, but that column will eventually have more data and I want to make it dynamic so I decided to place the new f...
Formulas and Functions
  • Twifoo's avatar
    Twifoo
    May 06, 2019
    If I1:I3 are blank, you may define CountRange, while I4 is selected, with this formula:
    =I6:INDEX(I6:I1048576,COUNTA(I6:I1048576))
    Thereafter, you may then enter this formula in I4:
    =COUNTIF(CountRange,"<>0")
Twifoo's avatar
Twifoo
Silver Contributor
May 06, 2019
If I1:I3 are blank, you may define CountRange, while I4 is selected, with this formula:
=I6:INDEX(I6:I1048576,COUNTA(I6:I1048576))
Thereafter, you may then enter this formula in I4:
=COUNTIF(CountRange,"<>0")
  • AVP68's avatar
    AVP68
    Copper Contributor
    May 07, 2019

    Twifoo  Thanks!

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      May 07, 2019
      You’re welcome.

Resources