Why Excel SUM totals don't match: "Numbers as text" | Find them with COUNT and ISTEXT, fix with VALUE

When you paste a CSV downloaded from accounting software or a bank into Excel and use SUM to total it, the result doesn't ...