The syntax for finding duplicates in a column is " =countif(range,criteria)", but what it should be when we want to find out the duplicates with multiple criteria,i.e. no. of occurrences of col A=x and B=y and C=z ?