Count of Capabilities per vendor

Options

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)



Best Answer

Answers