Count of Capabilities per vendor

Smartsheet_User

I am trying to find the count of capability for each vendor and can't figure out what is wrong in my formula. I have 2 columns Vendor and Capability in a tracker sheet and the below formula is referencing that sheet to exclude blank values and give the count for each vendor I am passing.

=COUNTIFS({Demo CTS Vendor Onboarding Tracker Capabilities}, {Demo CTS Vendor Onboarding Tracker Capabilities} <> "", {Demo CTS Vendor Onboarding Tracker Capabilities}, {Demo CTS Vendor Onboarding Tracker Vendor} = Vendor@row)

Mike TV

@Smartsheet_User

=COUNTIFS({Demo CTS Vendor Onboarding Tracker Capabilities}, {Demo CTS Vendor Onboarding Tracker Capabilities} <> "", {Demo CTS Vendor Onboarding Tracker Vendor}, = Vendor@row)

Mike TV

@Smartsheet_User

=COUNTIFS({Demo CTS Vendor Onboarding Tracker Capabilities}, {Demo CTS Vendor Onboarding Tracker Capabilities} <> "", {Demo CTS Vendor Onboarding Tracker Vendor}, = Vendor@row)

Smartsheet_User

Thank you Mike. It worked.

Smartsheet_User

How can I extract the below Vendor and multiple Capability information in separate rows from smartsheet in a metric sheet and calculate the number of days to execute the sow and present it in the dashboard as a bar graph? I extracted the below information as a report but want to know if this report can be represented as a graph or any other way to extract this information.