How can I count the number of items selected within a multi-select drop-down...?

adelmans

How can I count the number of items selected within a multi-select drop-down and multiply that amount by 25?

Nick Korna

Hi @adelmans,

If you're wanting to do it row by row:

=COUNTM([Dropdown column]@row) * 25

For the whole column:

=COUNTM([Dropdown column]:[Dropdown column]) * 25

These will count the number of selected items.

Hope this helps, if you've any questions or I've missed something then just post!