COUNTIFS - adding more than 1 criteria together

[dawidmns]

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()))

 

[nemmi69]

The format for multiple COUNTIFs is =COUNTIFS(range1,criteria1,range1,criteria2)

 

[Alex Blakenburg]

You can try this but it might only work if you have MS 365.

=SUM(COUNTIFS('Corporate Master'!F5:F1458,{"Expired Review","With QC - TRADE"},'Corporate Master'!I5:I1458,">="&(TODAY()-30),'Corporate Master'!I5:I1458,"<="&(TODAY())))

The countifs criteria are additive ie AND you are wanting a OR.

PS: it would be good if you updated your profile to show which version of Excel you are using since solution can vary based on what version you are using.

 

[dawidmns]

Thank you it worked. Profile updated too for the future.

 

[Alex Blakenburg]

Thanks for updating your profile. Glad it worked for you.