COUNTM Formula Help

Is there a way to use the COUNTM formula to count the number of selected dropdown options in a multi-select column (e.g., "Deposit Accounts") only when another column (e.g., "Region") equals a specific value (e.g., "East")?

For example, I want to count how many Deposit Accounts have been selected only for rows where the Region is "East".

The formula =COUNTM({Deposit}) pulls the correct total for all regions. However, when I try =COUNTM({Deposit}, IF({Regions}, "East", @cell )), it returns 10 instead of the expected 8.

Find more posts tagged with

Accepted answers

VBAGuru

@hjgeorge One option would be to add another column [Deposit Count], or whatever you want, with the formula =Countm(Deposit@row) and make this a column formula. You could then use the formula =Sumifs([Deposit Count]:[Deposit Count],Regions:Regions,"East")

All comments

VBAGuru

hjgeorge

@VBAGuru Thank you! This works perfectly. I appreciate the help!

VBAGuru

Glad I could help and thanks for helping me achieve the Ambassador Level!

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.