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

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