Totaling an Excel Column as It Is
Key points
- Copy the column
- Paste it
- See the result
With Column Statistics you can paste a copied Excel column as it is.
Steps
- Copy the column
- Paste it
- See the result
Cells that are not numbers are skipped.
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.