I’m trying to use the NOT operator but i’m getting an error, do you see something that is wrong with the formula below?
SumIf([Revenue],In([Stock],“C2”) NOT In([Company Name],“Leo Limited”))
I’m trying to use the NOT operator but i’m getting an error, do you see something that is wrong with the formula below?
SumIf([Revenue],In([Stock],“C2”) NOT In([Company Name],“Leo Limited”))
Hey Zachary!
I believe the issue here is that you do not have an “AND” operator before your “NOT”. If you add this I think it should work!