Frage stellen

Versionsgeschichte [zurück]

Klicken, um Version anzuzeigen/zu verstecken 1
Ursprüngliche Version

Get count (sum) of cells with specifically selected list value

Have a list of persons, defined a named range with them, for usage as a listbox in data validation.

on another sheet i have several cells where this validation is assigned

what I want to know is how many times (= in how many cells with type equals listbox) a specific list entry was selected in this sheet