Home

Multiple Selections Drop Down List (used a VBA code) & CountIfs

%3CLINGO-SUB%20id%3D%22lingo-sub-993360%22%20slang%3D%22en-US%22%3EMultiple%20Selections%20Drop%20Down%20List%20(used%20a%20VBA%20code)%20%26amp%3B%20CountIfs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-993360%22%20slang%3D%22en-US%22%3E%3CP%3EI%20used%20a%20VBA%20code%20to%20allow%20me%20to%20select%20multiple%20items%20from%20a%20drop-down%20list%20in%20a%20particular%20column.%3C%2FP%3E%3CP%3EI%20have%20two%20other%20columns%20with%20other%20drop-down%20lists%20but%20not%20allowing%20for%20multiple%20selections.%3C%2FP%3E%3CP%3EI'm%20using%20COUNTIFS%20to%20count%20for%20certain%20parameters%20among%20the%20three%20columns%20in%26nbsp%3B3%20x%202%20columns%20for%20each%20parameter.%3C%2FP%3E%3CP%3EWhen%20I%20use%20COUNTIFS%2C%20excel%20doesn't%20count%20the%20parameters%20in%20the%20multiple%20selection%20drop-down%20list.%20It'll%20count%20only%20if%20I%20select%20one%20item%20but%20once%20I%20select%20more%20than%20one%2C%20it%20doesn't%20count%20any%20of%20the%20parameters.%3C%2FP%3E%3CP%3EHow%20can%20I%20get%20excel%20to%20count%20what%20I%20want%20it%20to%20count%3F%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-993360%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECOUNTIF%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECOUNTIFS%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDrop-Down%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Teeah
New Contributor

I used a VBA code to allow me to select multiple items from a drop-down list in a particular column.

I have two other columns with other drop-down lists but not allowing for multiple selections.

I'm using COUNTIFS to count for certain parameters among the three columns in 3 x 2 columns for each parameter.

When I use COUNTIFS, excel doesn't count the parameters in the multiple selection drop-down list. It'll count only if I select one item but once I select more than one, it doesn't count any of the parameters.

How can I get excel to count what I want it to count?

Thanks.

Related Conversations
Context Menu Selecting (Laptop)
ganzo03 in Discussions on
4 Replies
SharePoint Lists - Expanded View Roadmap ID: 57302
Kotus-Tech in SharePoint on
9 Replies
Multi-value fields display no separator
Florian Hein in SharePoint on
1 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies