Help with formula

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?

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try this:

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

All comments

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. 👍️

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.