COUNTIFS nested formula help

Jan Peters

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?

Paul Newcome

To add two COUNTIFS together, you need to close each out on it's own.

=COUNTIFS(........) + COUNTIFS(............)

Or you can use an OR statement to combine two sets of criteria for the same range.

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

Jan Peters

Thanks Paul - is there something that I should be using other than 'CONTAINS' - I ultimately want a formula that will find 'Meal Replacement' and COUNT it whether it's "Meal Replacement" or "Meal Replacement - 2nd Solution" - I am not confident that the CONTAINS sub-string is working as I need it to? Would 'FIND' and COUNT make more sense?

Paul Newcome

The above should work just fine. I use CONTAINS functions A LOT.