Get instant live expert help on I need help with excel sum numbers ignore text

“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

The sum of NUMBERS, not text, add up to zero instead of the correct number.
Solved by D. D. in 27 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
Hi - quick question relating a query. I have quotation marks in my text but want to use the same text in a query. how can I ignore the quotation marks?
Solved by F. S. in 24 mins
I have a row with numbers like "8 ($10)", I want something which will calculate "## ($10)" (it must calculate "##" number). Make something which should ignore "($10)" things
Solved by O. A. in 15 mins
I have a spread sheet that has a few rows with duplicate numbers in them, I want the frequency and rank functions to ignore them.
Solved by I. J. in 27 mins