Using Countifs to Check for Multiple and Exact Conditions


Greetings! Reaching out to this group for assistance in creating a formula that counts the number of times a certain Product is associated with a given Account ID. The challenge is that the Account IDs may include the same characters but differ based on the case of a letter (a cap or small "a" at the end of the IDs shown below).

The objective is to find the quantity of Product A uniquely associated with Account ID 0011N00001FG8aA and uniquely associated with Account ID 0011N00001FG8aa. Similar formulas will be created to find the quantity of Products B and C for each unique Account ID as well.

Thank you for your assistance with this request.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!