Yes, it is possible to create a row that will only sum whatever is in a filtered column. Here are the steps to do it:
- Select the cell where you want to display the sum.
- Type the formula "=SUBTOTAL(9,range)" in the cell, where "range" is the range of cells you want to sum.
- Press Enter.
The "
9" in the formula tells Excel to use the
SUM function, and the "
range" argument specifies the range of cells to sum. The
SUBTOTAL function will only sum the visible cells in the filtered column, excluding any hidden cells.
Note: Make sure that the range you specify in the formula includes only the column you want to sum, and not any other columns that may be adjacent to it.