Count If Function

[Daniel1908]

Hello Together, 

I am looking for a solution to count the Product Numbers which have Product Key TH or LR, not having the Return Label A or B, Material beginning with 467* if the price is <=100€.

=Count({<Productkey={'TH','LR'},[ReturnLabel.]-={'A','B'},Material={'467*'}>}if([Price]={"<=100€"},Product Number))

Thanks for your help.

Kind Regards, 
Daniel

[agigliotti]

Hello @Daniel1908 ,

What's wrong with your exp?

Anyway you could try the below:

=Count( {< Productkey = {'TH','LR'},
[ReturnLabel.]-={'A','B'}, Material = {"467*"}, Price = {"<=100"} >} [Product Number] )

I hope it can helps.

Best Regards

[Daniel1908]

It did not work correctly. 

This works fine, thanks. 

I tried to add another criteria, just show empty fields (-) from column Request. 

Unfortuately It doesn't work, do you have an idea? 

[Request]-={'X'}

Kind Regards, 
Daniel