Get instant live expert help on how to sum text in excel

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a problem regarding to Learn How to Sum Text Values Like Numbers in Excel
Solved by K. A. in 18 mins
How do I get a cell value to equal zero in a sum function if it contains text?
Solved by M. S. in 12 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
Hi, if i have multiple text fields with associated numbers how can i get them to sum all the related text and numeric fields
Solved by Z. Y. in 24 mins
How to count cells incldes text in excel
Solved by E. J. in 24 mins