Hello SS Community,
I'm trying to count the number of instances two values appear together in a cell. From the following example, I would like to count how often "Contractor" and "Vendor" appear together, and furthermore I would like to sum the budget for those instances as well.
When I use the CountIf with Contains formula, it is giving me every instance the contractor appears in the column. Is there any way to achieve the given objective here?
Thank you,
Yogin