COUNTIF & Multi-Selection Dropdown -- Count multiple entries

SkiPatrolScott

@Paul Newcome

10-50 for listed patroller =COUNTIFS({BulletPatroller1}, Patroller@row, {Event}, [10-50]@row)

Paul, if this is confusing I will try to screen shot when I get to my machine. The above formula is pulling from our main sheet. [Event] has multiple options, in my summary sheet I have a field '10-50" which is populated with "10-50" so it is grabbing from [event] correctly.

THe [Patroller] is prepopulated and it is grabbing correctly from {BulletPatroller1} the 10-50 from {Event}..

HOWEVER>>>> there is a [Additional Patrollers] that can have multiple patrollers.. So is there a formula that will work like the above formula but instead of {bulletpatroller1} it would grab from {additional patrollers}?

Paul Newcome

@SkiPatrolScott I believe that @Genevieve P. may have already gotten you an answer on your other thread (below the one I linked to)?

https://community.smartsheet.com/discussion/comment/360588#Comment_360588