Google sheet: Count A Filter, returns 1 not 0 when no match

[WillSTARK]

Hi,

Here is my Formula,

=COUNTA(FILTER(A31:A900,Q31:Q900="Product - 1031"))

In column A there are Names
In column Q there are department names

I do not understand why the formula returns a 1 instead of 0 when there is no match between column A and Q

Any explanations?

Cheers

 

[RoryA]

If there are no results, FILTER returns #N/A and counta counts that as 1.

 

[WillSTARK]

I see thanks.
Then any suggestion to avoid that? or that it returns 0 ?