COUNTM Formula Help

hjgeorge

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.

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")

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")

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!