Cannot sum long columns. But can simple short column

[lorax73]

LibreCalc…
I just dont understand
I can “sum” a simple column of 3 or 5 numbers i type, etc

but a long line (result of download from bank/credit union)
wont sum, just shows the equation. I did find/replace and took out $ and -(negative) and ,(comma) nothing helped. not understanding. help? thx

[EarnestAl]

From the alignment, your numbers appear to be text. See this page for how to convert, Faq/Calc/How to convert number text to numeric data - The Document Foundation Wiki

[lorax73]

omg, EarnestAI that is amazing, thank you. The solution worked perfectly.
Lorax73