SUBTOTAL vs FREQUENCY!?

J

Jo

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
 

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 & Sum Question 0
Autofilter and subtotal 1
Round subtotals to two decimal places 0
Absolute value 2
Issue with nested data subtotals 3
Divide two numbers in data subtotal function 2
Slow subtotal and insert row 3
Frequency distribution and descriptive statististics 10

Top