I am trying to create a SUMIFS formula that checks multiple criteria with a wildcard. If the cell contains and of these cases, "½" , "½ₓ", "½ ₓ", at the beginning of the string, I want the value column AN added to the sum.
When I enter this formula below, I get the "There's a problem with this formula" error message.
=SUM(SUMIFS($AN$4:$AN$487,$AP$4:$AP$487,$BN$3,$AO$4:$AO$487,{"½" & "*","½ₓ" & "*","½ ₓ" & "*"}))
When I enter =SUM(SUMIFS($AN$4:$AN$487,$AP$4:$AP$487,$BN$3,$AO$4:$AO$487,{"½","½ₓ","½ ₓ"})), I don't get the same error, but the formula doesn't work as intended and does not collect all the values I am looking for.
Does anyone have any suggestions? Thank you in advance!
Bookmarks