A sample showing how I fix a spreadsheet that does not add up. The payments total showed R2,400 instead of R4,200 because one payment was stored as text. I corrected it and also fixed a missing bill number, a wrong header, a supplier name typo and inconsistent formats. All data is fictional.