If you are looking for subtotal after filter then try this :
Formula:
=SUBTOTAL(3,A$2:A$11)
Or
Formula:
=SUBTOTAL(103,A$2:A$11)
And if you want count in a regular way then :
Formula:
COUNTIF(A$2:A$11,"A")
If you are looking for subtotal after filter then try this :
Formula:
=SUBTOTAL(3,A$2:A$11)
Or
Formula:
=SUBTOTAL(103,A$2:A$11)
And if you want count in a regular way then :
Formula:
COUNTIF(A$2:A$11,"A")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks