David Yanofsky was riding the New York City subway when he noticed an ad for the new Surface tablet in the Spring Street station. The ad showed a budgeting spreadsheet used in planning a trip to Maui running in Excel 2013 on the Surface tablet. The budget has seven line items, including ones for air, hotel, car, surfing and diving. Unfortunately, the total at the bottom was wrong, as Yanofsky’s photo on Quartz.com shows.
How did it happen?
If you were creating an Excel worksheet and had to total five numbers, an Excel rookie might use a formula of =B1+B2+B3+B4+B5 as shown here:
Excel pros would instead use the AutoSum button and end up with =SUM(B1:B5).