Compare same text in three columns and count a different one

[Daniel1908]

Hello Together, 

I am looking for a solution to compare the same text in three columns and count a different one. 

For example:

If= Supplier A is equal to Supplier B and Product Key is "TH" count Material

Thanks for your help.

Kind Regards, 
Daniel

[rubenmarin]

Hi, you can try with =Count({<Prod={'TH'}>} If(SupA=SupB, Mat))

[Daniel1908]

Hi, 

that worked, thanks for your help. 

How can I exclude a text from a column? 

For example exclude 698758 from column Supplier C. 

Kind Regards, 
Daniel

[MayilVahanan]

HI @Daniel1908 

Try like this

=Count({<Prod={'TH'}, SupC -={698758} >} If(SupA=SupB, Mat))

[Daniel1908]

Hi Mayil,

Thanks for your help. 

How can I exclude another SupC? 698758 and 698452?

Kind Regards, 
Daniel

[MayilVahanan · Accepted solution]

HI Daniel,

You can add another value with comma separator.

=Count({<Prod={'TH'}, SupC -={698758, 698452} >} If(SupA=SupB, Mat))

[Daniel1908]

Hi Mayil, 

Thanks for your help.

Kind Regards, 

Daniel