I am attempting to construct a formula that refers to the value in a cell that is formatted with data validation and am not certain how to properly refer to the value. For example, if one of the values in the data validation is "core" and I want to add the values in a range based on whether or not the value in the data validation range is "core" i am using the following array formula =IF($L$12:$L$108="core",$I$12:$I$108). However, it does not appear to be working and is giving me a value of zero when in fact I know there are values that fit the criteria and therefore should be greater than zero. The data validation is entered as a range (e.g., =$w$4:$w$7). Thank you in advance for your assistance.
