I am trying to count all the cells that have information between two cells that are in the same column.

This is easy enough to do using =countif(cell1:cell2, "<>") the problem is that I may need to update the cells at some point and insert new cells between cell1 and cell2, in which case this new cell will not be counted.

Is there anything I can do other than manually updating the formula every time?

  • 1
    Do you know what is a cell range? Do you know what happens to a cell range reference when the related cell range is moved? Commented Jul 31, 2015 at 23:00

1 Answer 1


As Rubén hinted in a comment, the cell range reference cell1:cell2 will be automatically updated if you insert or delete cells within the range. For example: if you have a formula

=countif(A2:A10, "<>")

and insert a row between 2nd and 10th, the command will automatically change to

=countif(A2:A11, "<>")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.