Formula Assistance (COUNTM??)

Hello all,

My team and I are hoping to build a formula to do the following:

First, identify all items that belong to "Group A," then count how many items the rows that belong to group A have in "Color."

So, for example, the answer for this would be 4 (because there are 4 items in the "Color" column that belong to Group A).

We know that to count the "Color" column, we need to use COUNTM() and we have that working. However, we are not sure how to narrow that down to only the items in a specific group.

Could anyone help us with this?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!