Get instant live expert help on sum text in excel
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
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
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