Forum Discussion
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...
- 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")
