If you want to sum visible cells but don't need the total to be pasted to your table, you can select the range and see the sum of the selected cells on the Excel Status bar. Voila! Only the filtered cells in the column are summed up.
If you want to sum visible cells only, read on and learn how. In addition, please be prepared that the SUM function will work even with the values from hidden and filtered rows. However, you still need to enter the function manually. This option is really handy if you have a large column to sum in Excel and don't want to highlight the range. The total will appear in the correct cell. That's it! You will see the column summed. It's helpful if you have large ranges for calculation. You can enter the range address manually like =sum(B1:B2000). Now select the range with the numbers you want to total and press Enter on your keyboard.Click on the cell in your table where you want to see the total of the selected cells.Why would you need this? To total only some of the cells in a column or to specify an address for a large range instead of selecting it manually. You can also enter the SUM function manually. Enter the SUM function manually to sum a column In Excel This method is fast and lets you automatically get and keep the summing result in your table.
How to total columns in Excel with AutoSum Just click on the letter of the column with the numbers you want to sum and look at the Excel Status bar to see the total of the selected cells.īeing really quick, this method neither allows copying nor displays numeric digits. How to sum a column in Excel with one click
This tutorial shows how to sum a column in Excel 2010 - 2016.