(for this post some formulas and menu names are in spanish as my excel and computer are in spanish and excel formulas depend on this).
The formula is:
=AGREGAR(3;3;J:J)-1
The first two parameters are for the function itself. The important one is J:J which marks the column to count. What’s important here is this is not going to count filtered items in tables.
Watch out with headers! If you have headers in your table, add -1 to your formula.