When Non-numbers Are Mixed In
Key points
- Paste the numbers
- See the result
- Check the count
Column Statistics skips anything that is not a number when totaling.
Steps
- Paste the numbers
- See the result
- Check the count
The number skipped is shown so you can check.
Use "Sum, Average and Median of a Column of Numbers" (free)
Tools that go well with this
- Calculate Percentages, Discounts and % Change: Calculate percentages, discounts and % change instantly.
- Excel Column Number and Letter Converter: Convert Excel column numbers and letters.
- Swap Rows and Columns of a Table: Swap the rows and columns of a pasted table.