Count if displayed (filtered) RRS feed

  • Question

  • To only sum up filtered results, I use:  =SUBTOTAL(9,K12:K40012)

    I am looking for a similar function that will only count rows that are displayed when filtered.

    Count(K12::40012) counts all records, regardless of the filters, so I need something different.

    Monday, October 12, 2015 2:48 PM


All replies