I'm trying to create a formula so that if in cell E2
it says "Market", "Limit", or "Stop" it adds the numbers in cells L2
and M2
.
=SUMIF(E2, "Market" "Limit" "Stop", L2+M2)
These expressions are part of a data validation list, I'm not sure if that effects the result or not. I've tried the help files, Google searches and formula wizard. I just can't figure this out.