I have a 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")
which works fine, but I need it to also count all occurences of "AMV" in the same range, and return the total of all of them. I have tried using several variations of but none work the way I want it to, they just give me errors. Any ideas on this one?
Sincerely,
Nade
=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")which works fine, but I need it to also count all occurences of "AMV" in the same range, and return the total of all of them. I have tried using several variations of but none work the way I want it to, they just give me errors. Any ideas on this one?
Sincerely,
Nade