I'm trying to count the matching items in two cells to a reference in another sheet. Individually they work with COUNTIF and produce the associated result but then I want to test both it comes back with "0".

=COUNTIF({DNAC Adoption Range 1}, Partner106) = counts the correct partner name

=COUNTIF({DNAC Adoption Range 1}, Solution106) - counts the correct # solution name

=COUNTIFS({DNAC Adoption Range 1}, Operation106, {DNAC Adoption Range 1}, Partner106) - returns "0" but should return "1"

What am I missing?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!