Choosing specific file

[SusmitaM]

I have 3 files in a folder as attached and I want to get below output from each of the file using formula tool, so that i could get the accurate figures from each file. How should i do that? Please help, due to data confidentiality cannot mention the details.

Formula : " IF ([XXX] IN ("A", "B") AND [YYY] > 60) "

Output:

XXX       YYY
SBS        16
Client     177

[Raj]

@SusmitaM 
formula syntax should be
if condition then expected else expected endif