Hi guys
I have another questions, as you can see on the picture, I am trying to add 2 criterias together, With QC - Trade and Expired Review (there will be 2 more criterias added later on: Temporary Approval and: With RM - Trade). But I am doing something wrong, could you please help? As I am getting 0 which is wrong as above just With QC shows 11.
Also, the data is from another tab, for this reason you can see Corporate Master
=COUNTIFS('Corporate Master'!F5:F1458,"Expired Review",'Corporate Master'!F5:F1458,"With QC - TRADE",'Corporate Master'!I5:I1458,">="&(TODAY()-30),'Corporate Master'!I5:I1458,"<="&(TODAY()))
I have another questions, as you can see on the picture, I am trying to add 2 criterias together, With QC - Trade and Expired Review (there will be 2 more criterias added later on: Temporary Approval and: With RM - Trade). But I am doing something wrong, could you please help? As I am getting 0 which is wrong as above just With QC shows 11.
Also, the data is from another tab, for this reason you can see Corporate Master
=COUNTIFS('Corporate Master'!F5:F1458,"Expired Review",'Corporate Master'!F5:F1458,"With QC - TRADE",'Corporate Master'!I5:I1458,">="&(TODAY()-30),'Corporate Master'!I5:I1458,"<="&(TODAY()))