Get instant live expert help on sum if cell contains text

How do I get a cell value to equal zero in a sum function if it contains text?

Need to sum cell values IF they are adjacent to a cell which contains certain text (trying to quickly sum the totals of categories by category name)

If cell A1 contains value "xyz", I want cell A2 to require text be entered by user. If cell A1 contains anything other than "xyz", I don't need text entered into cell A2. How do I do this?

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?

please help populate column contents of 1 of 7 options. The formula should look in a single column for the digit 1,2,3,4,6 or it should understand that it is "blank". It should then populate with the contents of different columns accordingly. For example if it contains 1, should print text from cell A1, if its 2, B1, etc Actual references are: If K3 contains 1, print text of AH3 in AG3 If K3 contains 2, print text of AI1 in AG3 If K3 contains 3, print text of AJ1 in AG3 If K3 contains 4, print text of AK1 in AG3 If K3 contains 5, print text of AL1 in AG3 If K3 contains 6, print text of AM1 in AG3 If K3 is blank, print text of D3 in AG3