Help with Countifs & Contains formula

APS2011

I am trying to create a formula to count the number of orders that are on hold. However, we have several hold types, so I just need to count any order that says 'hold' in the field. Here is my current formula. Can you help me figure out why it is not working?

=COUNTIFS({Copy of Copy of LATAM Backlog Range 2}, "40 DEALER CAPITAL ORDER", {Copy of Copy of LATAM Backlog Range 2}, "40 DEALER CAPITAL ORDER", {Copy of Copy of LATAM Backlog Range 3}, "CAPEQUIP", CONTAINS({Copy of Copy of LATAM Backlog Range 4}, "Hold", @cell))

Paul Newcome

Your range/criteria set for CONTAINS is off a little.

=COUNTIFS(…………….., {Range}, CONTAINS("Hold", @cell))

Paul Newcome

Your range/criteria set for CONTAINS is off a little.

=COUNTIFS(…………….., {Range}, CONTAINS("Hold", @cell))

APS2011

Thank you!

Paul Newcome

Happy to help. 👍️