Count occurrences of each variable of a multi-dropdown list

Douglas Jerum

Hi, I'm building a lease administration tool to help negotiate some leases. Each row (lease) has several stages (preliminary, negotiating, at lease, executed lease, open). I want to create a dashboard metric to show how many rows are at a particular stage:

Preliminary - 5; Negotiating - 3; At Lease - 7, etc...

What would I do to count the occurrences of each variable in the drop down list so I can use them in the metric widget?

Thanks in advance!

Paul Newcome

You would create a list where each option is is listed and then use a COUNTIFS function to count how many of each.