The cell accepts the formula but doesnt give a numerical result. Already have to get more bands your cart and limited time. Numbers do not need to be wrapped in quotes, but they can be. Do a sum if statement in international certified professional by left. You can easily do the same for any error that you need to deal with. In all free, then we can use sumifs, we must match returns a single row.