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).…