Subtotal & Sum Question

J

Jo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUBTOTAL vs FREQUENCY!? 0
Need Help in numbering 1
Autofilter and subtotal 1
Round subtotals to two decimal places 0
SUMPRODUCT formula is summing text and I want it to stop doing that 2
Absolute value 2
#N/A Conversion 8
Problem with a MIN function 6

Top