“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

I have a problem regarding to Learn How to Sum Text Values Like Numbers in Excel

Solved by K. A. in 18 mins

pivot tables and text fields in the sum value column

Solved by K. Q. in 19 mins

Need to seperate text thats in a cell so i can sum them

Solved by G. C. in 23 mins

Need help with sum value and text..................

Solved by X. E. in 30 mins

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