How to count number of vendors in each country?

Hey Community,

I am simply trying to calculate the quantity of contracts assigned to each vendor per country (Ex: I want to see that IBM is covering 100 contracts for us in the United Kingdom).

The columns I have to use for this are the following:

Vendor assigned, Covered Country (on the same sheet)

Countries, Vendors (on a separate sheet, my metric sheet to perform the calc)

If anyone has an idea on how to help please let me know.

Thank you



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!