Totals That Don't Add Up: Text Numbers, Double Counting & Check Sums
This lesson is part of the course
In this lesson
Larkspur's Q1 cost report has no error codes but the total is wrong twice over. You remove the double-counted subtotals, find the numbers stored as text, measure what they leave out and reconcile the report with the ledger.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- #DIV/0! & Safe Division: IF Tests vs IFERROR Locked
- #N/A from Lookups: Trailing Spaces, Numbers Stored as Text & IFNA Locked
- #VALUE!: Text in Arithmetic, VALUE & SUBSTITUTE Locked
- #REF! & Broken References: Deleted Cells, Relative vs Absolute after Copying Locked
- #NAME? & #NUM!: Typos, Unquoted Text and Impossible Maths Locked
- ISERROR, ISERR, ISNA & ERROR.TYPE: Classify and Count Errors Locked
- Totals That Don't Add Up: Text Numbers, Double Counting & Check Sums Locked
- Model Audit Checklist: Check Cells & Red Flags Locked