COUNTIFS nested formula help

Options

I'm trying to get a count for multiple solutions but am getting the '#NESTED CRITERIA' error.

=COUNTIFS({Rapid Response Delivery Tracking Range 6}, CONTAINS("Meal Replacement", @cell) + COUNTIFS({Rapid Response Delivery Tracking Range 6}, CONTAINS("Meal Replacement - 2nd Solution", @cell)))


Essentially I need it to give me a total count for both 'Meal Replacement' and 'Meal Replacement - 2nd Solution' - what am I missing?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!