Subtotal & Sum Question
 

Hi,

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.

I tried this instead: SUBTOTAL(109, N ( FREQUENCY(A2:A46,A2:A46)
0 ) ) but got an error

Any way or alternative to overcome this?


Thanks,
Jo