COUNTIFS

[luisitocarrion1900]

How can i have the below formula count various statuses, its already counting the status "PM Approved" and need to add "Waiting PM Approval", "PM Certified"


=COUNTIFS(AIM!A:A,D5,AIM!G:G,"PM Approved")

 

[offthelip]

what about:

=COUNTIFS(AIM!A:A,D5,AIM!G:G,"PM Approved")+COUNTIFS(AIM!A:A,D5,AIM!G:G,"Waiting PM Approval")+COUNTIFS(AIM!A:A,D5,AIM!G:G,"PM Certified")