Contains/Has with Dropdowns

ELaz

Im using a Sum(Collect(..)) formula that collects data from a dropdown list(Roof, Ground and Canopy) using a dropdown list (Roof, Ground and Canopy), but it only collects it if the dropdown from the criteria has all values in the search range.

Is there a formula that it can collect if it contains any of the values from the search range? I.E. criteria is Roof and Ground (as a drop down value) and search range has only Roof (also as a drop down value).

I want that value to also be collected.

thanks

Kleerfyre

Two potential options, split your formula into two parts, or use an OR function. If you could share your current formula, we might could quickly help in any adjustment that might help you.