=countif

[Oceans]

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.

[FDibbins]

that is because a blank cell does indeed "not equal to" Reviewed. try using countifS() and include <>""

[jake.masters]

Maybe:

=COUNT(P4:P1800)-COUNTIF(P4:P1800, "=Reviewed")

[Oceans]

I am trying

=COUNTIFS(P4:P1800, "<>Reviewed", P4:P1800, "<>""")

But Excel is popping with a formula error which i am not able to resolve

[Oceans]

I applied this correction

=COUNTIFS(P4:P80,"<>""", P4:P80,"<>Reviewed")

but still the count is not accurate

[jake.masters]

I tested the old one and it worked. When I tested "<>""" it was somehow still counting blank cells because it was looking for "" and not a blank.

Try:

=COUNTIFS(P4:P80,"<>", P4:P80,"<>Reviewed")

[MarijnK]

Please try this
[code]
=countif(P4:P1800,"<>")
[code]
or if you only want to count cells with data other then blank
=counta(P4:P1800)

[Oceans]

This one works good

=COUNTIFS(P4:P80,"<>", P4:P80,"<>Reviewed")

[Oceans]

Maybe:
=COUNT(P4:P1800)-COUNTIF(P4:P1800, "=Reviewed")
It was giving a Negative 1794
But thanks for getting back to me