I need a formula similar to =IF(OR(AP8={"P","X"}), SUM(AJ8+$BD$4), IF(OR(AP8={"LM","C"}), "", "") But rather than P, X, LM, or C I need it to say that if AP8 contains "text" than sum SUM(AJ8+$BD$4) , but if there is no text in AP8 then do not sum SUM(AJ8+$BD$4). How do I write this?
Solved by G. F. in 22 mins