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

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

You should be able to use something like this...

=COUNTIFS({Source Sheet Vendor Assigned}, Vendors@row, {Source Sheet Covered Countries}, Countries@row)

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.