How to Sum Visible Cells Only in Excel - Step by Step

Описание: In this video, I talk about how to sum the visible cells only in Excel. Below is the step by step procedure:

Summing Visible Cells Only


1. Click on the cell where you want the sum of the visible cells to appear.
2. Type =SUBTOTAL( into the selected cell.
For summing, use 9 as the first argument. Your formula should look like this: =SUBTOTAL(9,.
3. Select the Range of Cells:
After the comma, select the range of cells you want to sum. For example, =SUBTOTAL(9, A1:A10).
Press Enter:
The cell will now display the sum of only the visible cells in the selected range.


#exceltips #exceltutorial #exceltricks