Formula error

Leighmercado

What is wrong with my formula?

=COUNTIFS({MBF Open SB Range 3}, "737", {MBF Open SB Range 4}, "top kit")

I made sure that the column with "737" and "top kit" are both text/numbers but im still getting 0 as total

AKnight

Hey @Leighmercado !

I would add CONTAINS like:

=COUNTIFS({MBF Open SB Range 3}, CONTAINS("737", @cell), {MBF Open SB Range 4}, CONTAINS("top kit", @cell))

Does this work?

AKnight

Hey @Leighmercado !

I would add CONTAINS like:

=COUNTIFS({MBF Open SB Range 3}, CONTAINS("737", @cell), {MBF Open SB Range 4}, CONTAINS("top kit", @cell))

Does this work?

Leighmercado

Yes, it worked! thank you very much!!!