SUBTOTAL vs FREQUENCY!?
 

Hi,

"Subtotal" has some functions that can be used in calculating
subtotals within a list. However, unfortunately FREQUENCY is not one
of the functions that can be used with SUBTOTAL!

I am using a formula like this: SUM(N(FREQUENCY(A2:A46,A2:A46)0))
but when I hide some rows the formula still include the hidden ones in
the calculations.

Any way or alternative to overcome this?

Thanks,
Jo