What should I do to count total values only from visible cells in filtered table in Excel ? When I apply the filter I see total values of all the cells, not only the visible ones.

Hi,

To count the total values only from visible cells in the table, you have to use SUBTOTAL function instead of COUNT or SUM function.

In SUBTOTAL function you have to use two arguments. The first argument is used to set a functionality and the second argument is used to define a range of cells.

To count only the filtered values, the formula should look like:

=SUBTOTAL(2;C2:C15)

To sum only the filtered values, the formula should look like:

=SUBTOTAL(9;C2:C15)

To count the total values only from visible cells in the table, you have to use SUBTOTAL function instead of COUNT or SUM function.

In SUBTOTAL function you have to use two arguments. The first argument is used to set a functionality and the second argument is used to define a range of cells.

To count only the filtered values, the formula should look like:

=SUBTOTAL(2;C2:C15)

To sum only the filtered values, the formula should look like:

=SUBTOTAL(9;C2:C15)

Related questions

## How to add side by side rows in excel pivot table ?

## Is CSV excel file Comma or Semicolon separated / delimited ?

## Check if value exists in column more than once or twice - Excel

## How to show Euro, Dollar or Pound sign on right in Excel ?

## Move excel chart horizontal axis to bottom - below negative values

## Invalid cell reference error in Excel vLookup function - #REF!

## How to calculate percentage changes / growth in Excel ?

Trending questions

Remove or hide bottom navigation bar with buttons on Android How to calculate inverse currency exchange rate ? Best free attractions in London - free things to do in London How to add side by side rows in excel pivot table ? How to change QWERTZ keyboard to QWERTY in Windows 10 ? Man Month calculation - how many man days or man hours ? How to calculate how many Man Days are 3 Man Hours ?

Remove or hide bottom navigation bar with buttons on Android How to calculate inverse currency exchange rate ? Best free attractions in London - free things to do in London How to add side by side rows in excel pivot table ? How to change QWERTZ keyboard to QWERTY in Windows 10 ? Man Month calculation - how many man days or man hours ? How to calculate how many Man Days are 3 Man Hours ?

Follow us on Facebook

2022 AnswerTabsTermsContact us