Help with formula

Lauren Hughes

I am wanting to count the number of drop down items selected in a cell, but I only want it to count in the cell for a specific row.

This is the sheet that i want to count the number of dropdown items from.

This is the sheet that i want the formula written in to return an output. Currently I have =IF(HAS({centers}, Center@row), COUNTM({july}), "") as the formula, but it is showing the total amount of items in each drop down selected for WHOLE list. What I want to see if for BIRMINGHAM = 3; Scottsdale = 4; Beverly Hills = 0

Can someone help?

Paul Newcome

Try this:

=COUNTM(COLLECT({July}, {Centers}, HAS(@cell, Center@row)))

Paul Newcome

Try this:

=COUNTM(COLLECT({July}, {Centers}, HAS(@cell, Center@row)))

Lauren Hughes

that worked, thank you so much!

Paul Newcome

Happy to help. 👍️