Formula issues

[patria_pr]

Hi there,

I'm getting a brain damage trying to figure out how I can add another critera to the same formula that is read it in the same column, below is the formula:

=COUNTIFS('WARTIME ACH AWDS TRACKER'!A:A,"*",'WARTIME ACH AWDS TRACKER'!O:O,"ACH",'WARTIME ACH AWDS TRACKER'!M:M,"CO",'WARTIME ACH AWDS TRACKER'!D,"AM")

The words that has to added are "AM" (already added) and "AMV"

 

[alow]

Do you mean you need to add another criteria column to the formula? Or have it look for AM or AMV in column D?