I have this formula
=COUNTIF(P4:P1800, "<>Reviewed")
The data so far are only in the cells from P4 to P8
the rest are blank, and I made sure to use Clear All for cells beyond P8

However the count is not accurate, but if i limit the range to P4:P8, i get more accurate count !

Why is that, and how can i keep it more dynamic, with no need to adjust the range every time more cells beyond P8 has data.