When building spreadsheets, I often SUM() up large sets of numbers in Excel. However, a common problem arises when you want to write --- or N/A to signify that a cell is intentionally empty. This causes SUM() to error.