Count total values only from visible filtered cells in Excel

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.
0
give a positive ratinggive a negative rating
12 Dec 2020 at 03:01 PM
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)
0
give a positive ratinggive a negative rating
13 Dec 2020 at 02:15 PM
Tim
Share on FacebookShare on TwitterShare on LinkedInSend email
x
x
Follow us on Facebook
2022 AnswerTabsTermsContact us