I have a google sheet where I want to look at columns A:C and see a unique count of Products they manage (col A) and have a condition to only count when col C = "Outreach". It seems to be working, but you can see in col F that Ike is being counted although he doesn’t have any products with an Outreach status:
formula is: =counta(UNIQUE(FILTER(A:A,(B:B=E3),C:C="Outreach")))
>Solution :
It happens because FILTER returns #N/A and COUNTA treats it as a value. To avoid it you need to wrap FILTER in IFNA that will return empty value:
=COUNTA(UNIQUE(IFNA(FILTER(A:A, B:B=E3, C:C="Outreach"))))